Dieter, thank you for responding. I made several attempts based on my understanding of your answer and I still am not getting it right. Here is the situation as I last tried it: "category", as passed to the form action, is a list generated by the user selecting multiple items from a listbox. --------------------------------------------------- from my form: (this part works fine) --------------------------------------------------- <tr><td><select name="category" size="10" multiple> <dtml-in sql_get_categories> <option value="<dtml-var category>" > <dtml-var category> </dtml-in> ---------------------------- from my form action ---------------------------- <dtml-in category prefix=test> <dtml-comment>this is the list</dtml-comment> <dtml-call name="sql_delete_a_category(trash='<dtml-var test_item>')"> <dtml-var test_item><br> <dtml-comment>used to verify items are looping</dtml-comment> </dtml-in> --------------------------------------- my SQL: (nothing happens) --------------------------------------- Arguments: trash delete from categories where category = '<dtml-var name="trash" sql_quote>' What am I doing wrong? My SQL returns with no error but doesn't delete the items I think I am passing. Thank you for your continued help. Roger Mallett
From: Dieter Maurer <dieter@handshake.de> To: "Roger Mallett" <rogermallett@hotmail.com> CC: zope@zope.org Subject: Re: [Zope] passing a zope <dtml-in...> list element to a sql method Date: Sun, 28 Sep 2003 22:31:17 +0200
Roger Mallett wrote at 2003-9-28 05:33 +0000:
I am attempting to access an element from a list and pass the element to a SQL method.
If "l" is a list, you access its "i"th element with "l[i]".
To pass an argument to a Z SQL Method, you pass it as keyword argument: "YourZSQLMethod(argument1=val1, argument2=val2,...)".
Dieter
_________________________________________________________________