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. i would be happy, if someone could help me
On Wednesday 18 December 2002 15:53, 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.
i would be happy, if someone could help me
checkout the advance tab in the sql method the default limit is 1000 hth
_______________________________________________ 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 )
-- http://www.kedai.com.my/ http://www.kedai.com.my/eZine http://www.zope.org/Members/kedai http://www.my-zope.org If you SMELLLL...
Am 18.12.2002, 08:53 Uhr schrob equality_now@dressyvagabonds.com <equality_now@dressyvagabonds.com>:
i wrote a sql-method which contains the SQL-Statement "SELECT * FROM table" called imageList [...] then i integrated forward and previous links, but if i click on the forward button i only get forward till to the 900d entry.
The result set of a ZSQL-Method is restricted to a maximum number of entries. Go to the "Advanced" Tab and change the setting of "Maximum rows to retrieve". HTH Jo. -- Internetmanufaktur Jo Meder ---------------------- Berlin, Germany http://www.meder.de/ ------------------- fon: ++49-30-417 17 63 33 Kollwitzstr. 75 ------------------------ fax: ++49-30-417 17 63 45 10435 Berlin --------------------------- mob: ++49-170- 2 98 89 97 Public GnuPG-Key ---------- http://www.meder.de/keys/jo-pubkey.txt
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
participants (4)
-
Bakhtiar A Hamid -
equality_now＠dressyvagabonds.com -
Jo Meder -
Tino Wildenhain