Page Comparison

var searchTerm = '%' + search + '%';
var sql = 'SELECT * FROM products WHERE prname LIKE ? OR prdesc LIKE ?';

var c1 = pjs.prepare(sql);
c1.setAttr(SQL_ATTR_CURSOR_SCROLLABLE, SQL_TRUE);
c1.bindParameters([searchTerm, searchTerm]);

c1.execute();