Hi Gustavo, for advanced "playing" just create a ZSQLMethod instance and play with it. It has more options then the simple test purpose on the connection object, which is obviously only there to simple test success with the connection and may be to create some tables on the fly. Certainly not to retrieve more then 1000 rows out of the database. (which sounds like not a good idea anyway in the web environment, thus the default value is set to 1000 - see advanced tab on ZSQL Methods) Regards Tino --On Dienstag, 3. Juli 2001 11:53 -0300 Gustavo Vieira Goncalves Coelho Rios <gustavo@ifour.com.br> wrote:
Dear gentleman,
I guess you could see my point.
I am no playing with a Z SQL Method object, it's a Z MySQL Database Connection Object. There no place where i can remove that limit x option for the query. Got what i mean?
Thanks again for your help.
PS: sorry teasing you up!
On Tue, Jul 03, 2001 at 01:41:01PM +0200, Tino Wildenhain wrote:
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
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- While having never invented a sin, I'm trying to perfect several.