[Zope] RETRACTION - [Zope] Bug in Z ODBC DA?
Martijn Faassen
M.Faassen@vet.uu.nl
Tue, 20 Apr 1999 16:12:07 +0200
Retraction -- retraction -- retraction
There is NO bug in Z ODBC DA. At least not my bug. Oops. I've been
stupid.
I'd been writing:
delete from entiteit
where <!--#sqlvar entiteit_id type="int"-->
while I should've written:
delete from entiteit
where <!--#sqltest entiteit_id type="int"-->
The former translates to:
delete from entiteit
where <some number>
And <some number> turns out to have been always > 0 in my experiments.
So it says:
delete from entiteit
where TRUE
which attempts to delete *all* records, and that obviously gives me
referential integrity problems.
Stupid, stupid stupid. Sorry to bother you all.
Regards,
Martijn