Versions Compared

Version Old Version 6 New Version 7
Changes made by

Alex Roytman

Alex Roytman

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This API executes a prepared statement. It should be be called after parameter binding.

The API can also be called in the form of a method attached to a statement object as follows: stmt.execute().

Parameters
  1. Handle from a prepared statement. This parameter can be omitted if the API is called as a statement method.

Exception Handling

An Error instance will be thrown with the following properties:

...

SearchTerm
Code Block
languagejavascript
title
Called directly
var searchTerm = '%' + search + '%';
var sql Statement = 'SELECT * FROM PRODUCTSP ';
  Statement += 'WHERE products WHERE prname LIKE ? OR prdesc LIKE ?';

var Statementc1 += 'UPPER(PRNAME) LIKE ? ';
  Statement += 'OR ';
  Statement += 'UPPER(PRDESC) LIKE ? ';
  Statement += 'OR ';
  Statement += 'UPPER(PRIMAGE) LIKE ? ';
  Statement += ' FOR FETCH ONLY';

 pjs.prepare(sql);
pjs.setStmtAttr(c1, SQL_ATTR_CURSOR_SCROLLABLE, SQL_TRUE);
pjs.bindParameters(c1, [searchTerm, searchTerm]);

pjs.execute(c1);
Code Block
languagejavascript
titleCalled as a method
var searchTerm = '%' + search + '%';
var sql = 'SELECT * FROM products WHERE prname LIKE ? OR prdesc LIKE ?';

var c1 = pjs.prepare(Statementsql);
  pjsc1.setStmtAttrsetAttr(c1, SQL_ATTR_CURSOR_SCROLLABLE, SQL_TRUE);
  pjsc1.bindParameters(c1, [
    [SearchTerm, SQL_PARAM_INPUT],
    [SearchTerm, SQL_PARAM_INPUT],
    [SearchTerm, SQL_PARAM_INPUT]
  ][searchTerm, searchTerm]);

  pjsc1.execute(c1);


Requirements

This API requires the Profound.js Connector module.