[Zope] Deleting data using ZSQL

[Phil Harris]

Steve,

Your user for the dataase does have permission to delete does it?

Phil
----- Original Message -----
From: "Steve Drees" <drees@the-bridge.net>
To: <technews@egsx.com>; <zope@zope.org>
Sent: Friday, September 29, 2000 3:00 PM
Subject: RE: [Zope] Deleting data using ZSQL


>
>
> > -----Original Message-----
> > From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
> > technews@egsx.com
> > Sent: Thursday, September 28, 2000 10:17 PM
> > To: zope@zope.org
> > Subject: [Zope] Deleting data using ZSQL
> >
> >
> > Hi,
> >
> > I am writing a dtml method that deletes data from a database, and I
found
> > myself unable to do this.  It seems that ZSQL is used to insert, update
> > and query a database. but can not use
> > "delete from table where var=<dtml-var foo>"
>
>
> delete from this_table where var=<dtml-sqlvar foo type=string>
> is what I use (Changing type accordingly of course).
>
> >
>
> _______________________________________________
> 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 )