Allow rawSQL plugin to accept argument array

Discuss all feature requests you have for a new Servoy versions here. Make sure to be clear about what you want, provide an example and indicate how important the feature is for you

Allow rawSQL plugin to accept argument array

Postby SteveInLA » Wed Sep 05, 2007 5:56 pm

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)
SteveInLA
 
Posts: 233
Joined: Thu Jul 29, 2004 12:00 am
Location: Southern Oregon, USA

Postby ROCLASI » Wed Sep 05, 2007 6:02 pm

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.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Postby SteveInLA » Wed Sep 05, 2007 6:11 pm

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.
SteveInLA
 
Posts: 233
Joined: Thu Jul 29, 2004 12:00 am
Location: Southern Oregon, USA


Return to Discuss Feature Requests

Who is online

Users browsing this forum: No registered users and 11 guests