[Zope] Multiple delete from selection list

Gitte Wange gitte@mmmanager.org
24 Apr 2001 08:59:51 +0200


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 )