[Zope] Multiple Inserts Using Sybase DAV

[Kia A. Arab]

The sql_delimiter does work with Sybase. However, the thing that is
tripping me up is that the values I'm trying to get into the database
are in a list. The html form is a multiple selection menu and the
selections are put in a list under one name (in this case,
NAME=keywords). 

The ACTION on my html form is a dtml-method that verifies the input, and
then makes a dtml-call to a sql method. But, how do you make a  dtml
call to a python script and pass it a 'list' parameter? If I can pass it
correctly, the Python-script would then manipulate the list and send
each list value to a sql-method to insert the value in a database. Tried
every which way, but not luck. I can't seem to 
1 - get the values from my html form passed to a python script, then
2 - get the python script to pass the list values to a sql-method

Any help is appreciated. Again, please email me directly.
Thanks,
K.

Gilles Lenfant wrote:
> 
> <dtml-var sql_delimiter> is supposed to work with most DA.
> Dunno for Sybase but it works with MySQL.
> Workaround (no sql_delimiter) :
> Try a python script that calls both (or any number of) ZSQL methods in
> sequence providing the parameters through a dict or mapping object:
> 
> context.mysqlmethod({'param1': value1, 'param2': value2})
> ...
>