[Zope] begin/commit

[Andy Dustman]

On Mon, 2 Jul 2001, Gustavo Vieira Goncalves Coelho Rios wrote:

> 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.

If you are using ZMySQLDA-2.0.7, putting a - at the beginning of your
*connection string* will force it to not use transactions. If your server
supports transactions (i.e. you have BDB tables or InnoDB tables),
transactions are used automatically; otherwise they are not, so I must
assume your server supports them.

> 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

Set the max_rows property on your Z SQL Method to 0, and a limit will not
be added. You also may be able to trick it by putting an SQL comment above
that line.

-- 
Andy Dustman         PGP: 0xC72F3F1D
    @       .net     http://dustman.net/andy
I'll give spammers one bite of the apple, but they'll
have to guess which bite has the razor blade in it.