[Zope] A question about ZSQL

[Bobby Brewster]

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 at 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 at 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 )
>