This API binds parameters to a prepared statement.
Before using this API, you must call pjs.prepare(), so that you can pass in the handle from that call.
Parameters
- The handle created by pjs.prepare().
- An array of parameters for each SQL parameter marker. Each element in the array must be another array, where the first element is the value of the parameter and the second is the parameter type. For example:
[[paramA, profound.SQL_PARAM_INPUT], [paramB, profound.SQL_PARAM_INPUT]]
Examples
pjs.connect("*LOCAL");
var _stm = pjs.prepare("SELECT * FROM PJSTEST/PRODUCTSP WHERE PRID = ?");
pjs.bindParameters(_stm, [
[gPrid, pjs.SQL_PARAM_INPUT]
]);
Requirements
This API requires the Profound.js Connector module.