[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