I am assuming you are adding all fields into one table and thus would like to use one SQL query. I would create my SQL query as usual and use search replace in a text editor to add in the <dtml-sqlvar ....s. A little manual editing should not be an issue and suggest that cross check what the search replace did. Shapehead. On Sun, 6 Feb 2005 07:25:12 -0800 (PST), Low Kian Seong <zope_low@yahoo.com> wrote:
Dear people,
I have a survey form that has about 26 fields in them and I want to put the data into a postgresql database via a psycopg adapter. Problem is when i build the insert using a zsql, do i have to manually create each field using <dtml-sqlvar ? seems very long and unproductive way to do it.
Doing it using an external method, I will loose the niceties of dtml-sqlvar such as auto escaping of input and such.
Suggestions anyone ?
__________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )