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 -
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 -
From: Paul Zwarts <paul.zwarts@oratrix.com>
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
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 - 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 )
-- Manuel Amador (Rudd-O)
participants (3)
-
Evan Simpson -
Manuel Amador (Rudd-O) -
Paul Zwarts