RE: [Zope] ZMySQLDA problems after upgrade
You will get 0 rows if you use max_rows=0. -Randy -----Original Message----- From: Ron Bickers [mailto:rbickers@logicetc.com] Sent: Friday, January 26, 2001 10:05 AM To: Ron Bickers; Andy Dustman; Randall F. Kern Cc: zope@zope.org Subject: RE: [Zope] ZMySQLDA problems after upgrade
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Ron Bickers Sent: Friday, January 26, 2001 11:28 AM To: Andy Dustman; Randall F. Kern Cc: zope@zope.org Subject: RE: [Zope] ZMySQLDA problems after upgrade
How about excluding the automatic LIMIT clause if max_rows is set to 0? Would that confuse people?
Oh! It already does that. So if you want to make your own LIMIT clause, just set max_rows to 0. Correct me, Andy, if this is a bad thing. _______________________ Ron Bickers Logic Etc, Inc. rbickers@logicetc.com
On Fri, 26 Jan 2001, Randall F. Kern wrote:
You will get 0 rows if you use max_rows=0.
OK, I agree that this is a legit bug, and I am in the process of working up a new patch. I'll send it off-list when it's ready. -- Andy Dustman PGP: 0xC72F3F1D @ .net http://dustman.net/andy "Normally with carbonara you use eggs, but I used lobster brains instead." -- Masahiko Kobe (Iron Chef Italian): 30-year-old Giant Lobster Battle
Yeah... I just realized that's what broke my 'select LAST_INSERT_ID() as newid' query where a LIMIT clause causes a MySQL error. I had max_rows set to 0 and all of a sudden I was getting Zope errors. This worked in earlier DAs. Thanks for the upcoming fix, Andy. _______________________ Ron Bickers Logic Etc, Inc. rbickers@logicetc.com
-----Original Message----- From: Randall F. Kern [mailto:randy@spoke.net] Sent: Friday, January 26, 2001 1:22 PM To: Ron Bickers; Andy Dustman Cc: zope@zope.org Subject: RE: [Zope] ZMySQLDA problems after upgrade
You will get 0 rows if you use max_rows=0.
-Randy
participants (3)
-
Andy Dustman -
Randall F. Kern -
Ron Bickers