[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