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 -