[Zope] REQUEST.set size

[Paul Zwarts]

Hi again,

Some extra info from reproducing the error again:

ValueError: PQsendQuery() -- query is too long.  Maximum length is 16382

This error comes from the traceback AFTER the method is called to store the
list in the dbms so I assume that the error is actually the DBMS field size
and NOT the request.set as I had imagined.

Then that leads to overflow tables... which I cant seem to create in PGSQL
as I know with Solid. Anyone have suggestions?

Cheers,
Paz

Paul Zwarts wrote:

> Hi all,
>
> I am new to Zope but worked for 2 years in a dev-env called Uniface so
> Im fairly up to speed on Zope quickly. But I am having a problem writing
> data through a REQUEST.set that is larger than its apparent limit.
> (sorry can remember the exact error i get from Zope)
>
> What I am trying to do is collect in a field a large list of emails that
> are gathered in a dtml-in statement with a REQUEST.set('all', all +
> email) nested in the loop. While appending the namespace to store the
> data in PGSQL, i always get the size error which i assume is coming from
> the publisher saying that a the request can only have a byte size of
> 1800 bytes or so.
>
> Im not so hot with straight SQL because Uniface had its own methods, so
> Im not sure if I can append data directly to a stored field or if I need
> to continue trying to use the REQUEST.set. After the hundreth occurence
> in the IN, the namespace I use to store the appended data, so I cannot
> fully make a list of 2000 occurences. Any ideas?
>
> Sorry, no code to show what Im doing but it should be pretty easy to
> understand for all you veterans out there...
>
> TIA,
>
> --
> Paz
> Oratrix Development BV
> http://www.oratrix.com
> GRiNS SMIL Editor
> -
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )

--
Paz
Oratrix Development BV
http://www.oratrix.com
GRiNS SMIL Editor
-