dbQueryExecPrepared

Purpose

Executes a previously created and prepared query.

Format

ret = dbQueryExecPrepared(qid)

Parameters:

qid (scalar) – query number.

Returns:

ret (scalar) – 1 for success and 0 for failure.

Examples

// Prepare a query
qid = dbCreateQuery(db_id);
dbQueryPrepare(qid, "SELECT * FROM
     USERS WHERE ID = :id");

// Set `:id` placeholder
dbQueryBindValue(qid, ":id", "5");

// Execute `qid` query
dbQueryExecPrepared(qid);

// Return results as a string array
results = dbQueryFetchAllSA(qid);

// Reset `:id` placeholder
dbQueryBindValue(qid, ":id", "10");

// Re-execute the query with new value
dbQueryExecPrepared(qid);

// Return new results as a string array
results = dbQueryFetchAllSA(qid);