Page Comparison

var table = "productsp";
 
pjs.define("productsp_out", { type: 'data structure', qualified: true, dim: 50, extName: table  });
pjs.define("searchQuery", { type: "char", length: 30 });
 
pjs.clear(productsp_out);

searchQuery = '%' + 'Garmin' + '%';
var c1 = pjs.prepare("selectSELECT * fromFROM "productsp + table  + " where WHERE prdesc likeLIKE ? orderORDER byBY prid");
c1.bindParameters(searchQuery.trim());
c1.execute();
 
pjs.fetch(c1, productsp_out, 50);
 
c1.close();