[Zope] Strange problem with ZMySQLDA

[Kevin L]

Hello,

I get the following error when calling a Z SQL Method within a
<dtml-in> tag:

Warning:  Some non-transactional changed tables couldn't be
rolled back

For example:

<dtml-in "_.range(0,5)">
  <dtml-call "insert_rec(num=sequence-number)">
</dtml-in>

The method just inserts one row into a table. Calling it on it's
own works fine, as does executing it via the "Test" function.
But calling it from inside <dtml-in> always gives the error.

According to the mysql log file it runs the query (althoug the
record does not get inserted) and then does a ROLLBACK (why???).

Has anyone encountered this before? thanks much

-Kevin

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/