[Zope] Multiple Inserts Using Sybase DAV

[tgraham@speakeasy.net]

Hi Kia,

Search the archives for the string "delete multiple records sql python"  It will give some good code examples of what I think you're trying to accomplish.

Basically I think you need to use the 'list' argument in your html form and pass the list it to a python script for manipulation

Todd


On 25 Jan 2002, Kia A. Arab wrote:

> 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}) ...
> >
>
> _____________________________________________-
> __
> Zope maillist - Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope **
> No cross posts or HTML encoding! ** (Related
> lists - http://lists.zope.org/mailman/listinf-
> o/zope-announce http://lists.zope.org/mailman-
> /listinfo/zope-dev )