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.define("productsp_out", { type: 'data structure', qualified: true, dim: 50, elements: {
  "prid": { type: "packed decimal", length: 5, decimals: 0, initValue: 105 },
  "prname": { type: "char", length: 30 },
  "prdesc": { type: "char", length: 60 }
}})
  
pjs.define("searchQuery", { type: "char", length: 30 });
  
var c1;
pjs.connect("*LOCAL");
pjs.clear(productsp_out);
 
 
searchQuery = '%' + 'Garmin' + '%';
c1 = pjs.prepare("select prid, prname, prdesc from demolib/productsp where prdesc like ? order by prid");
pjs.bindParameters(c1, [
  [searchQuery.trim(), pjs.SQL_PARAM_INPUT]
]);
pjs.execute(c1);
 
pjs.fetch(c1, productsp_out, 50);
 
pjs.close(c1);
pjs.disconnect();

Requirements

This API requires the Profound.js Connector module.