[Zope] begin/commit

[Tino Wildenhain]

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.