--On Sonntag, 6. Februar 2005 7:25 Uhr -0800 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.
I am not completely sure but I assume that you can specify **kw as argument of a ZSQL method. So you could loop over the key-value pairs *but* you have to deal on your own *somehow* with different types (int,string, date etc.) (keep in mind that <dtml-sqlvar expects the name of an argument and its type). Depending on the database you could specify everything as 'string' but let the database to the conversion e.g. to 'int'. But at the point when you're dealing with dates or other types this approach will slap you into your face. -aj