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 )