[Zope-DB] SQL Variables

[Antonio Orlando]

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