Evan, Are you using <cfupdate> or raw SQL?
At 11:49 PM 7/1/02 -0400, you wrote: >Yep. That's what has my SELECT statements working properly instead of >truncating my large text fields. But my UPDATE statements are bombing out >with the same "query string is too long" error. Weird, huh? > >Evan > > > -----Original Message----- > > From: Jillian Carroll [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 01, 2002 11:20 PM > > To: CF-Linux > > Subject: RE: Take 2: CF5/Postgres - "Query string is too long" > > > > > > Evan, > > > > I've finally got my configuration (identical to your specs) working. > > > > I can't recall which conversation I've had with who, so this might be > > something you've already done. When you recompiled the driver, > > did you make > > sure to change the following? > > > > At the end of the file you find: > > > > /* sizes */ > > #define TEXT_FIELD_SIZE 16380 /* size of text fields (not > > including null term) */ > > #define NAME_FIELD_SIZE 32 /* size of name > > fields */ > > #define MAX_VARCHAR_SIZE 254 /* maximum size of > > a varchar (not including null term) */ > > > > -- > > Jillian > > > > -----Original Message----- > > From: Evan Lavidor [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 01, 2002 8:21 PM > > To: CF-Linux > > Subject: Take 2: CF5/Postgres - "Query string is too long" > > > > > > Well, I've upgraded to Postgres 7.2 and RedHat 7.3, and I've re-recompiled > > the unixODBC driver. My select statements all work without a hitch, but > > when I'm doing an update or an insert, I'm still getting the "Query string > > is too long" ODBC error. > > > > Anyone have any ideas? > > > > Thanks, > > > > Evan > > > > > -----Original Message----- > > > From: Jillian Carroll [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, June 26, 2002 10:37 AM > > > To: CF-Linux > > > Subject: RE: CF5/Postgres - "Query string is too long - Still having > > > problems > > > > > > > > > Thank you Evan, this fixed one of my problems. :) > > > > > > And with an upgrade to the latest version, I appear to be clear sailing. > > > Whew! I was really hoping not to have to move to MySQL. > > > > > > -----Original Message----- > > > From: Evan Lavidor [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, June 25, 2002 1:54 PM > > > To: CF-Linux > > > Subject: RE: CF5/Postgres - "Query string is too long - Still having > > > problems > > > > > > > > > Jillian, > > > > > > After you were done compiling, did you move the new > > > libodbcpsql.so file that > > > was created to /opt/coldfusion/lib/ (or whatever your install > > > directory for > > > CF is)? > > > > > > I rebuilt the module per rudi's message and replaced it in the CF > > > directory, > > > and restarted the CF service for good measure and everything > > > started working > > > much better. (Many thanks to those who helped me!) I've still > > > got a couple > > > of issues I'm debugging, but I'm not getting the "query string too long" > > > error anymore. > > > > > > Thanks, > > > > > > Evan > > > > > > > -----Original Message----- > > > > From: Jillian Carroll [mailto:[EMAIL PROTECTED]] > > > > Sent: Tuesday, June 25, 2002 11:44 AM > > > > To: CF-Linux > > > > Subject: CF5/Postgres - "Query string is too long - Still having > > > > problems > > > > > > > > > > > > I have installed the new UnixODBC driver for Postgres... is > > > there anything > > > > special I need to do so that CF will use it from now on? > > > > > > > > I've restarted Postgres and CF, and I'm still getting the > > > following error: > > > > > > > > Error Diagnostic Information > > > > ODBC Error Code = 08S01 (Communication link failure) > > > > > > > > Error while executing the query; Query string is too long > > > > > > > > Any help would be appreciated. > > > > > > > > -- > > > > Jillian > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
