Re: [Zope-DB] Suggestions If Any Please ! ! ! ! !

2005-11-18 Thread Philip Kilner
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: [EMAIL PROTECTED]
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


Re: [Zope-DB] Suggestions If Any Please ! ! ! ! !

2005-11-17 Thread Andreas Jung



--On 18. November 2005 12:58:46 +0530 Rajesh <[EMAIL PROTECTED]> 
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

pgplHMmiz0dIO.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


[Zope-DB] Suggestions If Any Please ! ! ! ! !

2005-11-17 Thread Rajesh




  
  

  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
   
  Thanks & Regards
  Rajesh
   
   

  

  
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db