[Zope-DB] displaying all results from a SQL query

Charlie Clark charlie at egenix.com
Tue Aug 10 07:11:37 EDT 2004

On 2004-08-09 at 19:29:37 [+0200], Laura McCord 
<Laura.McCord at doucet-austin.com> wrote:
> Hi,
>  I am using a Z SQL Method to retrieve results from my SQL Server. I
> noticed that only the first twenty results appear is there a way to make
> all results appear with links "Next 20 Results" or "Previous 20
> Results".

Hi Laura,

this is part of the batching function for DTML object or PageTemplates. 
Check the source and you will see you can adjust the size of this. In 
addition of the Zope Cookbook you'll find an alternative batching method 
for PageTemplates.

Charlie Clark

Professional Python Services directly from the Source
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::

More information about the Zope-DB mailing list