[Zope-DB] SQL Variables

Antonio Orlando aorlando2002@yahoo.com.br
Fri, 28 Jun 2002 11:19:42 -0400


I would like to know how is sent this sql to the database server.

paramColumnA = 10

select * from tableA where columnA = <dtml-sqlvar paramColumA type="string">


so,

a) select * from tableA where columnA = 10

or

b) select * from tableA where columnA = :param1
and then send the parameters.

or

c) I dunno


I ask that, because of the SQL caching at the DB server...

Thanks,

Antonio Orlando