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 > > > > > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ 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.
