[Zope] Delete multiple posts

[Casey Duncan]

Gitte Wange wrote:
> 
> On 03 Apr 2001 10:30:01 -0600, Casey Duncan wrote:
> > Gitte Wange wrote:
> > >
> > > Now I get the following error after hitting the submit button:
> > > Error Type: error
> > >             Error Value: You have an error in your SQL syntax near
> > > '['2', '2', '2', '2', '2', '2', '2', '2', '2']' at line 1
> > >
> > > Yes I am stupid but I don't understand what the problem is.
> > > The argument for my sql method is: ids:list
> > >
> >
> > What is the SQL code you used?
> >
> > --
> > | Casey Duncan
> > | Kaivo, Inc.
> > | cduncan@kaivo.com
> > `------------------>
> 
> The one you wrote:
> DELETE FROM clips WHERE <dtml-sqltest name="ids" column="id" type="int"
> multiple>

The reason why I asked is that the list is of strings not ints. Assuming
the id is an int in the database, you need to change the checkbox names
to "ids:int:list" which I believe will result in a list of ints being
passed to the SQL method.

Also, does it show you the SQL generated in its entirety when you get
the error? If so, what is it?

-- 
| Casey Duncan
| Kaivo, Inc.
| cduncan@kaivo.com
`------------------>