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 )