[Zope-DB] Dynamically setting ZSQL-Method parameters

Charlie Clark charlie at begeistert.org
Thu Oct 9 13:31:54 EDT 2003


On 2003-10-09 at 15:10:04 [+0200], Gál László wrote:
> If your DB server support this, you can do the following: Add an argument 
> 'limit=default_limit' to your ZSQL Method, then u can write a query like 
> this:
> 
> SELECT x 
>  FROM y
>   etc.
> LIMIT  &dtml-limit;

thanx for the tip. PostgreSQL supports limits so that's what I'm using. It 
seems "max_rows" has to be set to 0 so as not to conflict with this.

Charlie



More information about the Zope-DB mailing list