Re: [Zope] ZSQL method broken on 2.1.6

2000-06-11 Thread Dieter Maurer
Andreas writes: ZSQLMethod's "advanced" property 'Maximum number of rows retrieved' makes no sense to me. It prevents stupid queries to kill Zope. Assume, such a query returns 100.000.000 records. This probably will let Zope require several GB memory. As I know so far there is no way to

RE: [Zope] ZSQL method broken on 2.1.6

2000-06-11 Thread Ron Bickers
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andreas Sent: Saturday, June 10, 2000 1:59 AM To: Umesh Soni Cc: Phill Hugo; [EMAIL PROTECTED] Subject: Re: [Zope] ZSQL method broken on 2.1.6 (using zope 2.1.6 with ZMySQLDA-2.0.0a1

Re: [Zope] ZSQL method broken on 2.1.6

2000-06-09 Thread Phill Hugo
Umesh Soni wrote: (using zope 2.1.6 with ZMySQLDA-2.0.0a1 and MySQLdb-0.2.1) Hi there, I had this ZSQL method (simplified for clarity) working on 2.1.4 select id, nickname from bboard where id=50 order by id desc limit 30 Remove either the limit 30 or the LIMIT 1000 Advanced

Re: [Zope] ZSQL method broken on 2.1.6

2000-06-09 Thread Umesh Soni
Umesh Soni wrote: (using zope 2.1.6 with ZMySQLDA-2.0.0a1 and MySQLdb-0.2.1) Hi there, I had this ZSQL method (simplified for clarity) working on 2.1.4 select id, nickname from bboard where id=50 order by id desc limit 30 Remove either the limit 30 or the LIMIT

Re: [Zope] ZSQL method broken on 2.1.6

2000-06-09 Thread Andreas
Umesh Soni wrote: Umesh Soni wrote: (using zope 2.1.6 with ZMySQLDA-2.0.0a1 and MySQLdb-0.2.1) Hi there, I had this ZSQL method (simplified for clarity) working on 2.1.4 select id, nickname from bboard where id=50 order by id desc limit 30 Remove either