qie.getParameterizedQuery

Signature: qie.getParameterizedQuery(query)

Returns: ParameterizedQuery pQuery - a ParameterizedQuery wrapper object. To see the methods available on ParameterizedQuery, refer to the 'Parameterized Query' menu.

Returns a ParameterizedQuery wrapper object for the given query.

Note

Named parameters can be defined in the query using one of the accepted parameter prefix characters (colon ':' or at sign '@'). Parameter values can be set using one of the 'Set Parameter' methods (setInt() etc.). For example: SELECT * FROM patient WHERE patientName = :name The query may also contain node tags to be evaluated, however it is recommended that for user supplied data a named parameter is used instead.

Parameters

Type	Name	Description	Default
String	query	the SQL statement

Example

var isReadOnlyQuery = false;
var isQuoteValues = false;
var timeStampFormat = null; // let it use the default timestamp format. 
var query = "INSERT INTO test_table (`id`, `item`, `description`) " +
"VALUES (:id, :item, :description)";
// Create a Statement object
var pQuery = qie.getParameterizedQuery(query);

pQuery.setInt('id', 14);
pQuery.setString('item', 'Snake plant');
pQuery.setString('description', 'Spikey plant with varigation.');

pQuery.doQuery('EMR Database', isReadOnlyQuery, isQuoteValues, timeStampFormat);