[Zope-DB] Passing a list to a ZSQL method?

Dieter Maurer dieter at handshake.de
Wed May 19 17:34:45 EDT 2004


Bryce Harrington wrote at 2004-5-18 17:37 -0700:
>I have a table to insert records with arbitrary numbers of columns
>into.  To achieve this, I'd like to pass the ZSQL method a list object
>and construct the SQL statement like...
>
>INSERT INTO my_table (
>       record_uid,
>    <dtml-in params>
>       param_<dtml-var sequence-item> <dtml-if expr="! sequence-end">,</dtml-if>

Learn about the "prefix" attribute of "dtml-in".

It will make your life much (!) easier...

-- 
Dieter



More information about the Zope-DB mailing list