[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Johnson
Sent: Tuesday, May 09, 2006 11:40
To: 'user-list zope'
Subject: [Zope3-Users] SQL
The following code seems to be buggy somehow, but I’m
not clear how or why. It seems for some reason that the first SQL
“insert” query I run does not get processed, while the second one
does. I’ve tried numerous variations on this with no success.
I’ve done inserts before without problems.
# The transaction ID “dj3” already exists in all
cases, so both queryForResults calls should
# throw an exception, however only the second, third, fourth
query = "insert into transactions (transid) values ('dj3')"
DatabaseException: (1062, "Duplicate entry 'dj3' for
201 Main Street
Fort Worth, TX 76102
(877) 572-8324 x2200