- Code: Select all
var key = catkey;
var maxReturedRows = 10;//useful to limit number of rows
var query = 'SELECT catid FROM cat WHERE catkey = key';
var dataset = databaseManager.getDataSetByQuery(controller.getServerName(), query, null, maxReturedRows);