Allow rawSQL plugin to accept argument array

Classic Servoy
1

Can the rawSQL plugin be changed to accept an argument array the same way that databaseManager.getDataSetByQuery() and controller.loadRecords() does? For security reasons, I like that I can mask arguments in my query using the question mark and pass an array to the function that substitutes the array’s values for the question marks. I don’t seem to be able to have this option if I am using plugins.rawSQL.executeSQL(), and I find myself using the plugin quite a bit lately.

Thanks,
Steve in LA

Servoy Developer
Version 3.1.6-build 410
Java version 1.5.0_07-87 (Mac OS X)

2

Hi Steve,

The rawSQL plugin that comes with Servoy 3.5 already does that. I am not sure if you can use that plugin with 3.1 but you could try.

Hope this helps.

3

I searched through the change lists for 3.5 and didn’t see anything that indicated this feature. I have not been able to test 3.5 yet, but it is next on my production schedule. Thanks for the quick response.