Hi there Thanks for the quick response. I tried both suggestions and first gave the same error whereas the second causes some other error. I delved deeper and found my dtml-in tag that gives you the ability to navigate to the next record was missing a next. <dtml-in sqlSelectAllCustomers next size=1 orphan=1 start=query_start> <dtml-if next-sequence> <a href="<dtml-var URL><dtml-var sequence-query >query_start=<dtml-var next-sequence-start-number>"> (Next) </center></a> Thanks for you help Grant

...

...

Casey Duncan <cduncan@kaivo.com> 10/04/2001 16:15:18 >>> Grant Murphy wrote:

Hi

When I use the following tag, the result only contains the first and second records in the postgres table. When setting size to "2" it gives me all the records but two at a time. Is this a known problem or am I doing something wrong?

<dtml-in sqlSelectAllCustomers size=1 start=query_start>

Thanks Grant

You might try: <dtml-in name="sqlSelectAllCustomers" size=1 orphan=0 start=query_start> or perhaps: <dtml-with expr="sqlSelectAllCustomers(REQUEST)[query_start]"> -- | Casey Duncan | Kaivo, Inc. | cduncan@kaivo.com `------------------> _______________________________________________ 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 )