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 arrays. 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.
[[paramA, profound.SQL_PARAM_INPUT], [paramB, profound.SQL_PARAM_INPUT]]
For each marker, there must be another element in the top array.
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.