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

Ian Bicking ianb at colorstudy.com
Tue May 18 21:37:23 EDT 2004


On May 18, 2004, at 7:37 PM, Bryce Harrington wrote:
> 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>

That should be <dtml-if "not _['sequence-end']">

--
Ian Bicking | ianb at colorstudy.com | http://blog.ianbicking.org




More information about the Zope-DB mailing list