pjs.bindParameters()

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, SQL_PARAM_INPUT], [paramB, SQL_PARAM_INPUT]]
```

Example

pjs.connect("*LOCAL");  
var _stm = pjs.prepare("SELECT * FROM PJSTEST/PRODUCTSP WHERE PRID = ?");
pjs.bindParameters(_stm, [
  [gPrid, SQL_PARAM_INPUT]
]);

Requirements

This API requires the Profound.js Connector module.