dbQueryGetBoundValues

Purpose

Returns an Nx2 string array containing the placeholders and their corresponding values in a query.

Format

bound_values = dbQueryGetBoundValues(qid)
Parameters:

qid (scalar) – query number.

Returns:

bound_values (Nx2 string array) – The first column contains the placeholders and the second column contains the corresponding values.

Examples

// Add `MYSQL` to list of database connections
db_id = dbAddDatabase("MYSQL");

// Create and prepare `qid` query
qid = dbCreateQuery(db_id);
dbQueryPrepare(qid, "SELECT * FROM
  PEOPLE WHERE FIRST = :fname AND
  LAST = :lname");

// Set `:fname` placeholder
dbQueryBindValue(qid, ":fname", "John");

// Set `:lname` placeholder
dbQueryBindValue(qid, ":lname", "Doe");

// Print all `qid` placeholders
print "Vars = " dbQueryGetBoundValues(qid);

will print

Vars =
   :fname   John
   :lname   Doe