I'm having exactly the same problem, I hope somebody has the answer! :) -----Original Message----- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 7:58 AM To: CF-Linux Subject: RE: CF5/Postgres - "Query string is too long
One more (I hope this is the last one) question. I'm running RedHat 7.1 and CF5, so the unixODBC driver that I have for Postgres is the one that came with CF, and I don't believe that I have unixODBC installed as a whole package. I've downloaded the source, and I see the section that you're talking about, but is it possible to simple recompile the driver without installing all of unixODBC? Thanks again, Evan -----Original Message----- From: Fabio Serra [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 23, 2002 4:56 PM To: CF-Linux Subject: RE: CF5/Postgres - "Query string is too long At 17.45 23/06/2002, you wrote: >Thanks for your response. Not to sound like a total newbie, but since I am >relatively new to Linux and Postgres, can you give me a clue where I might >look for this setting? Is this in a conf file somewhere, or is it in files >that I then need to (re)compile? If I remember rightly you need to compile unixodbc after changing unixODBC-2.2.1/Drivers/Postgre7.1/psqlodbc.h 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) */ Using this driver I suggest you to use <cfqueryparam> in SQL INSERT, otherwise special chars are not properly ecaped :-( Anyone knows if there are the same problems with cfmx, jdbc and PostgreSQL? -------------------------------------------------- FABIO SERRA - faser(at)faser.net PGP available -------------------------------------------------- ______________________________________________________________________ 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.
