Steve,
Your user for the dataase does have permission to delete does it?
Phil
----- Original Message -----
From: "Steve Drees" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, September 29, 2000 3:00 PM
Subject: RE: [Zope] Deleting data using ZSQL
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> > [EMAIL PROTECTED]
> > Sent: Thursday, September 28, 2000 10:17 PM
> > To: [EMAIL PROTECTED]
> > 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 - [EMAIL PROTECTED]
> 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 )
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
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 )