[Zope] Deleting data using ZSQL

Kees de Brabander cj.de.brabander@hccnet.nl
Fri, 29 Sep 2000 10:26:12 +0200


----- Original Message ----- 
From: <technews@egsx.com>
To: <zope@zope.org>
Sent: Friday, September 29, 2000 5:17 AM
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 table where var= <dtml-sqlvar foo type=string>

in your Z SQL method will do the trick, at least it does for me

cb