[Zope] ZSQL-Method Bug????

Tino Wildenhain tino@wildenhain.de
Wed, 18 Dec 2002 10:47:32 +0100


Hi Equality,

--On Mittwoch, 18. Dezember 2002 08:53 +0100 
equality_now@dressyvagabonds.com wrote:

> i wrote a sql-method which contains the SQL-Statement "SELECT * FROM
> table" called imageList
>
> Table contains about 3000 entries.
>
> I created a DTML-Document and wanted to show all entries with a edit
> and delete link. I did it like this:
>
> <dtml-in "db.imageList()" size="1" start=query_start>
> ...
> </dtml-in>
>
> then i integrated forward and previous links, but if i click on the
> forward button i only get forward till to the 900d entry.

Just have a look at the "advanced" tab of your ZSQL Method,
there is a default:

Maximum rows to retrieve [ 1000]

I think this is responsible for your effect.

Regards
Tino