[Zope] (no subject)

[gitte@babytux.dk]

DATA
Subject: Re: [Zope] Delete multiple posts
From: Gitte Wange <gitte@babytux.dk>
To: Casey Duncan <cduncan@kaivo.com>
In-Reply-To: <3AC9F716.EE878D4A@kaivo.com>
References:
	<DB56BAD3BFCED3119D3100D0B72386560B242C22@wcgtule103.wcg.williams.com>		<986
	 286103.1359.3.camel@squidbitch> 
	<3AC99E2D.DE16F4E0@wildenhain.de>		<986307332.1399.0.camel@squidbitch> 
	<3AC9E2EA.95BF9353@kaivo.com> <986313280.1248.0.camel@squidbitch> 
	<3AC9F716.EE878D4A@kaivo.com>
Content-Type: text/plain
X-Mailer: Evolution/0.10+cvs.2001.04.03.08.00 (Preview Release)
Message-Id: <986315227.1248.2.camel@squidbitch>
Mime-Version: 1.0
X-Mailer: Evolution/0.10+cvs.2001.04.03.08.00 (Preview Release)
Date: 03 Apr 2001 18:28:23 +0200

On 03 Apr 2001 10:15:18 -0600, Casey Duncan wrote:
> Gitte Wange wrote:
> > 
> > Well that helped a little.
> > I set the Form ACTION-tag to sqlDeleteClips (which is my sql method) and
> > the checkbox name to "ids:list"
> > When I hit the submit button, you see a Zope page where there is a input
> > box to enter the ids in .. but I just want it do delete the ones that
> > are selected ???
> > 
> 
> You can't point the action of the form directly to the SQL method
> because it is not a web template. I would suggest having the form call
> itself and add some dtml logic at the top to determine that the user
> deleted something. Have it then fire off the SQL method before drawing
> the checkboxes. Something like so:
> 
> <dtml-if delete>
>       <dtml-call name="sqlDeleteClips">
> </dtml-if>
> 
> <form action="&dtml-URL;">
> <dtml-in sqlSelectClips>
>     <input type="checkbox" name="ids:list" value="&dtml-id;" />
>     <dtml-var name="title"><br />
> </dtml-in>
> <input type="submit" name="delete" value="Delete" />
> </form>
> 
> Substitute your field names for "id" and "title" above.
> -- 
> | Casey Duncan
> | Kaivo, Inc.
> | cduncan@kaivo.com
> `------------------>


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

-- 
************************
Gitte Wange Jensen

System Squid Developer
MMManager Aps
+45 29 72 79 72

gitte@mmmanager.org
************************