I have some values in an array and want to use them in a query, using the 'IN' operator.
I've been struggling around and ended up converting the array to literal text and add this to my query string:
- Code: Select all
function getRecordsWorking()
{
var $array = new Array(globals.idA ,globals.idB)
var $param = '(\'' + $array.join('\',\'') + '\')';
var $query = '';
$query += 'SELECT *' + ' ';
$query += 'FROM dummy' + ' ';
$query += 'WHERE k_owner_id IN ' + $param;
var $server = 'myserver';
var $max = -1;
var $dataset = databaseManager.getDataSetByQuery($server, $query, null, $max);
var $countRec = $dataset.getMaxRowIndex();
}
Isn't there anything like this that can be used????:
- Code: Select all
function getRecordsNotWorking()
{
var $array = new Array(globals.idA ,globals.idB)
var $query = '';
$query += 'SELECT *' + ' ';
$query += 'FROM dummy' + ' ';
$query += 'WHERE k_owner_id IN (?)';
var $server = 'myserver';
var $max = -1;
var $args = new Array();
$args[0] = $array;
var $dataset = databaseManager.getDataSetByQuery($server, $query, $args, $max);
var $countRec = $dataset.getMaxRowIndex();
}
Maybe another easier syntax than the one I use now???
Thnkx a lot!