[Zope] Deleting data using ZSQL

[Kees de Brabander]

----- 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