Raw SQL. I never use <cfupdate> or <cfinsert>. I am not using <cfqueryparam>'s in my update or insert statements, though.
Evan > -----Original Message----- > From: Brett Frisch [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 02, 2002 12:06 AM > To: CF-Linux > Subject: RE: Take 2: CF5/Postgres - "Query string is too long" > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ 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.
