[Zope] A question about ZSQL
shapehead at gmail.com
Sun Feb 6 19:38:01 EST 2005
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.
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.
> Zope maillist - Zope at zope.org
> ** No cross posts or HTML encoding! **
> (Related lists -
> http://mail.zope.org/mailman/listinfo/zope-dev )
More information about the Zope