29 Sep
2000
29 Sep
'00
8:26 a.m.
----- 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