Re: [AOLSERVER] SQL placeholders

2008-04-03 Thread Jade Rubick
You can probably just steal the db code from OpenACS. Jade On Wed, Apr 2, 2008 at 1:44 PM, Andrew Piskorski [EMAIL PROTECTED] wrote: On Wed, Apr 02, 2008 at 02:39:57PM +0100, Xavier Bourguignon wrote: Ok, so how do I get this OpenACS db_* AP to work? You would have to install OpenACS:

Re: [AOLSERVER] SQL placeholders

2008-04-03 Thread Xavier Bourguignon
Hi all, I just want to thank you for the information provided, very useful. On 03/04/2008, Jade Rubick [EMAIL PROTECTED] wrote: You can probably just steal the db code from OpenACS. Jade On Wed, Apr 2, 2008 at 1:44 PM, Andrew Piskorski [EMAIL PROTECTED] wrote: On Wed, Apr 02, 2008 at

[AOLSERVER] SQL placeholders

2008-04-02 Thread Xavier Bourguignon
Hi All, Is it possible to have an SQL statement pre-written in a Tcl variable like this: set adminop_sql {select * from tadminop where status = ?} Then call this [ns_db select $db $adminop_sql 'A'], basically, is it possible to pass values for SQL to use in place of the (?) ? Thanks --

Re: [AOLSERVER] SQL placeholders

2008-04-02 Thread Andrew Piskorski
On Wed, Apr 02, 2008 at 10:18:11AM +0100, Xavier Bourguignon wrote: set adminop_sql {select * from tadminop where status = ?} Then call this [ns_db select $db $adminop_sql 'A'], basically, is it possible to pass values for SQL to use in place of the (?) ? What you're talking about is called

Re: [AOLSERVER] SQL placeholders

2008-04-02 Thread Xavier Bourguignon
Ok, so how do I get this OpenACS db_* AP to work? Do I have to add something is my config file? How do I make the calls, is there some doc somewhere about this? Thank you On 02/04/2008, Andrew Piskorski [EMAIL PROTECTED] wrote: On Wed, Apr 02, 2008 at 10:18:11AM +0100, Xavier Bourguignon

Re: [AOLSERVER] SQL placeholders

2008-04-02 Thread Andrew Piskorski
On Wed, Apr 02, 2008 at 02:39:57PM +0100, Xavier Bourguignon wrote: Ok, so how do I get this OpenACS db_* AP to work? You would have to install OpenACS: http://openacs.org/ However, if you are currently using AOLserver stand alone, that's probabably not what you want to do, not just in order