Hi Gustavo, --On Montag, 2. Juli 2001 21:51 -0300 Gustavo Vieira Goncalves Coelho Rios <gustavo@ifour.com.br> wrote:
Hi folks,
First, i would like to thanks all of you who provided me with the necessary help to get zope + mysql running, THANKS!
I am facing a "problem": i added a mysql connection to my folder, zope is executing a begin + my query + commit. How may i stop zope from doing that. I want it only execute <my query>, nothing more, nothing else.
Thats a feature of zope. The support for transactions is relatively new in mysql. However it makes sense. I cant think of a case where it can get in the way. May be you can show me where the problem with the transaction lives? Then, you might modify the DA or write your special own.
Another problem: Just some of the query i run works when testing mysql connection. For instance, the following query does not work: select now()
Looking at mysql log i saw zope exec the folloging:
select now() limit 1000
limit 1000 is not nessecary. Look at the "advanced" tab of ZSQL Methods for options to the query. There might be a problem with the now() call concerning names. Try select now() as now as a workaround. Regards Tino