[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