Multiple delete from selection list
Hello, I know I have asked this question before but I still have some problems. I have a list of some items I want to be able to delete. Each item is listed with some informations and a checkbox. You can check as many items as you would like and when you hit the delete button below the list of items, the items should be deleted in the database. The name of the checkbox is: delClips:list Then I tried to do this: <dtml-in delClips> <dtml-call sqlDelClips> </dtml-in> But I get an error: Error Type: error Error Value: You have an error in your SQL syntax near '['68', '69']' at line 1 I hoped that the <dtml-in> tag would iterate through the list. How do I do it then ? Regards, Gitte
Gitte, as far as I can see, this would depend very much on the contents of sqlDelClips. Could you post that one? gitte@mmmanager.org wrote:
Then I tried to do this: <dtml-in delClips> <dtml-call sqlDelClips> </dtml-in>
But I get an error: Error Type: error Error Value: You have an error in your SQL syntax near '['68', '69']' at line 1
I hoped that the <dtml-in> tag would iterate through the list.
Cheers, Ben -- Ben Peter - Feldstrasse 8 - 35091 Coelbe Ben.Peter@t-online.de ph: (+49) 6421 983520
On 24 Apr 2001 03:01:29 +0200, Ben Peter wrote:
Gitte,
as far as I can see, this would depend very much on the contents of sqlDelClips. Could you post that one?
The sqlDelClips method: arguments: id code: DELETE FROM clips WHERE id=<dtml-var id> The call to the sqlmethod: <dtml-in delClips> <dtml-call expr="sqlDelClips(id=delClips)"> </dtml-in>
gitte@mmmanager.org wrote:
Then I tried to do this: <dtml-in delClips> <dtml-call sqlDelClips> </dtml-in>
But I get an error: Error Type: error Error Value: You have an error in your SQL syntax near '['68', '69']' at line 1
I hoped that the <dtml-in> tag would iterate through the list.
Cheers, Ben
-- Ben Peter - Feldstrasse 8 - 35091 Coelbe Ben.Peter@t-online.de ph: (+49) 6421 983520
_______________________________________________ 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/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (3)
-
Ben.Peter＠t-online.de -
Gitte Wange -
gitte＠mmmanager.org