Mailing List Archive

--On 18. November 2005 12:58:46 +0530 Rajesh <rajeshg@kestoneresearch.com>
wrote:

> Hi All,
>
> I'm Having problem in Zsql Method ,which return recordset
> dictionary,containing key<--.>value pairs, this recordset returns
> only 1000 records ,Even if my Sql query satisfies more than 1000 records ,
> Looking forward for suggestions/alternatives
>
>

Look at the properties tab of your ZSQL method. There should be a property
limiting the resultset to 1000 rows.

-aj

p.s. please learn to use a reasonable subject....

Hi Rajesh,

Rajesh wrote:
> I'm Having problem in Zsql Method ,which return recordset
> dictionary,containing key<--.>value pairs,
> this recordset returns only 1000 records ,Even if my Sql query satisfies
> more than 1000 records ,
> Looking forward for suggestions/alternatives
>

Look at the "Advanced" tab of your ZSQL method - there is a property
there called "Maximum rows to retrieve" which is limiting your result
set size. The default is 1,000 - you need to identify an appropriate value.

Please don't send HTML mail with graphics to the list - plain text only,
please.


--

Regards,

PhilK

Email: phil@xfr.co.uk
PGP Public key: http://www.xfr.co.uk
Voicemail & Facsimile: 07092 070518

"You'll find that one part's sweet and one part's tart:
say where the sweetness and the sourness start."
- Tony Harrison
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db