Query string is too long

[fhilliard]

I'm running into errors when I try to post a large block of text into a PostgreSQL text field using Cold Fusion Linux. I get a "query string is too long" message, even though I can post the same data with pgpPgAdmin. However, phpPgAdmin has the same issue if I increase the text length. First there is a limit to the amount you can drop into an edit box. Secondly, if you max that out, a Cold Fusion query into the same text field will produce less text than is in the box. I have upgraded to PostgreSQL 7.1 to remove the tuple limit and I have checked off accept long text strings in the CF administrator. Any suggestions?
Frank Hilliard

http://frankhilliard.com/

 

[rycamor]

I'm not familiar with ColdFusion, but if you are getting a "query string is too long" error, then that probably has nothing to do with Postgres at all. There is simply a limit to the amount of data that you can pass through a browser query string. I imagine you are using a form with the METHOD set to "GET". If so, try using METHOD="POST", which will not append the data on the query string, but will post it in urlencoded fashion, hidden from the querystring. This will allow a much greater amount of data to be passed.

 

[fhilliard]

No, I'm using POST. I've just been told in another forum there's a 32Kb limit to ANY POST operation through Netscape,, also a limit in Apache to the amount that can be posted. Maybe that's the issue. Humm.

 

[rycamor]

That's an awfully large textarea field. How exactly are you doing this? Are you having users paste a large amount of text into the textarea? If so, why not just do some sort of text file upload?

Another way to handle it is to break up the data into multiple forms, but that could be a real pain.

 

[fhilliard]

I'm building a self-publishing website in which clients can upload whole pages in a text block. The limits can be reached easily, but Cold Fusion has limits that are tighter than the Netscape limit. Here's two examples (check the extensions). You'll notice that the PHP example processes about twice as much data as the Cold Fusion one if you scroll down to the red text.

http://frankhilliard.com/capo/news/test.cfm

http://frankhilliard.com/capo/news/test.php

Frank Hilliard