pjs.bindParameters()

Bind parameters to a prepared statement.

Before using this method, you must use pjs.prepare() and pass in the handle from that call.

Parameters

The handle which is created from pjs.prepare().
An array which has an array. Each element in the array must be another array, where the first element is the value of the parameter and the second is what parameter type it is.
- ```
[[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.