You should look at the pg driver, I think it can emulate bind variables, or maybe it is part of the db_* API of OpenACS.
I also have a wrapper API for ns_db which has more of a stored procedure type API. Here is a link to an example application: http://junom.com/gitweb/gitweb.perl?p=twt.git;a=tree;f=packages/dbo Most of the API are used on this tcl page: http://junom.com/gitweb/gitweb.perl?p=twt.git;a=blob;f=packages/dbo/www/select-relations.tcl The queries are defined in individual files: http://junom.com/gitweb/gitweb.perl?p=twt.git;a=tree;f=packages/dbo/queries In general, bind variables is something which is handled by the driver, because there is no standard on how to do it. Some use ?, some use :varname. tom jackson On Wednesday 16 April 2008 13:04, Xavier Bourguignon wrote: > Hi Brett, > > Thanks for the message. > > I just wanted to try it with pgtcl. > My problem with the underlying db api in aolserver is that there is no > mechanism for binding variables to an SQL statement, e.g: > > set sql { > select > * > from > table > where > status = ? > } > > There is no mean to bind a variable to the placeholder. May be the db > api is not matured yet, but this would certainly be a worth while > addition. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
