question using 'IN' parameter with addFoundSetFilterParam

Classic Servoy
1

When I run this:

controller.addFoundSetFilterParam('sales_rep_id', 'IN', globals.glogins_accessible_users);

where globals.glogins_accessible_users is a string like (23,45,77), and then run this:

controller.loadAllRecords();

I get this:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s). [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).

The string from the global is the same string I use to format various SQL querys such as:

var query = 'SELECT pk_id FROM database.table WHERE sales_rep_id IN ' + globals.glogins_accessible_users;

and it works fine. I have tried hard-coding a string value in place of the reference to the global, I tried removing the parenthesis from the string and I tried converting the string to an array and have had no luck. I checked to make sure that this worked:

controller.addFoundSetFilterParam('sales_rep_id', '=', 32);

and it does. Any ideas?

Thanks,
Steve

2

IN is only supported for more than 1 value:

var array = new Array(globals.glogins_accessible_users1,globals.glogins_accessible_user2,globals.glogins_accessible_user3)
controller.addFoundSetFilterParam('sales_rep_id', 'IN', array);
3

My bad. When I said I had tried an array as a value, I was converting my string to an array incorrectly. Once I fed it a proper array, it works fine. Very VERY handy for my application. I will however make a request that you have heard before and ask for a way to clear the addFoundSetFilterParam without having to close the solution.

Thanks,
Steve