Mailing List Archive: Can I change the ZSQL max

Can I change the ZSQL max_rows default value?

Feb 6, 2007, 1:29 AM

Post #1 of 5 (3091 views)

Good day,

We use Zope 2.8, still from ZMI. We ran into the 1000 limit several
times. Instead of remembering to set it to a higher value, I would
like to change the ZSQL max_rows default to 5000.

Is it possible to do this?

Friendly greetings, Robert-Reinder

--

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

Re: Can I change the ZSQL max_rows default value? [ In reply to ]

charlie at egenix

Feb 6, 2007, 1:33 AM

Post #2 of 5 (2963 views)

Permalink

Am 06.02.2007, 10:29 Uhr, schrieb Robert-Reinder Nederhoed
<rr@nederhoed.com>:

> Good day,
> We use Zope 2.8, still from ZMI. We ran into the 1000 limit several
> times. Instead of remembering to set it to a higher value, I would like
> to change the ZSQL max_rows default to 5000.
> Is it possible to do this?

Yes, click on the "Advanced" tab of your ZSQL method.

Charlie

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

Re: Can I change the ZSQL max_rows default value? [ In reply to ]

maciej.wisniowski at coig

Feb 6, 2007, 2:18 AM

Post #3 of 5 (2965 views)

Permalink

> We use Zope 2.8, still from ZMI. We ran into the 1000 limit several
> times. Instead of remembering to set it to a higher value, I would
> like to change the ZSQL max_rows default to 5000.
>
> Is it possible to do this?
A bit dirty hack but it is at:

lib/python/Shared/DC/ZRDB in class DA

If you want then you may modify 'max_rows' value there.

or override this in lib/Python/Products/ZSQLMethods

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

Re: Can I change the ZSQL max_rows default value? [ In reply to ]

robert at redcor

Feb 6, 2007, 8:45 PM

Post #4 of 5 (2972 views)

Permalink

Robert-Reinder Nederhoed wrote:
> Good day,
>
>
> We use Zope 2.8, still from ZMI. We ran into the 1000 limit several
> times. Instead of remembering to set it to a higher value, I would like
> to change the ZSQL max_rows default to 5000.
>
> Is it possible to do this?
>
>
> Friendly greetings, Robert-Reinder
>
> --
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://mail.zope.org/mailman/listinfo/zope-db
>
in your zsql object there is aan "advanced" tab. there you can set the limit. if you set it to 0 all rows will be returned.
robert

Re: Can I change the ZSQL max_rows default value? [ In reply to ]

dieter at handshake

Feb 8, 2007, 12:38 PM

Post #5 of 5 (2960 views)

Permalink

Robert-Reinder Nederhoed wrote at 2007-2-6 10:29 +0100:
>Good day,
>
>
>We use Zope 2.8, still from ZMI. We ran into the 1000 limit several
>times. Instead of remembering to set it to a higher value, I would
>like to change the ZSQL max_rows default to 5000.
>
>Is it possible to do this?

It is also (beside the options already outlined in other replies) possible
to use so called "monkey patching" to modify thee value.

For details, search for it.

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

Mailing List Archive

Mailing List Archive

Attached Files: