Re: [Zope] REQUEST.set size
maybe you should try to put your data in a list or a dictionary.
Anyone can help with the syntax? I can't remember... =)
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 - [EMAIL PROTECTED]
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
)
--
Manuel Amador (Rudd-O)
Re: [Zope] REQUEST.set size
From: Paul Zwarts <[EMAIL PROTECTED]> > ValueError: PQsendQuery() -- query is too long. Maximum length is 16382 This is purely a PostgreSQL issue; Some (all? not sure.) versions of PostgreSQL have a hard limit on the length of query strings. You have to break your query into multiple smaller queries. Cheers, Evan @ digicool & 4-am ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] REQUEST.set size
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 - [EMAIL PROTECTED]
> 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
-
___
Zope maillist - [EMAIL PROTECTED]
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 )
