At 00.39 Tuesday 02/07/02 -0400, you wrote:
>Raw SQL. I never use <cfupdate> or <cfinsert>. I am not using
><cfqueryparam>'s in my update or insert statements, though.
You should use cfqueryparam with postgres, that's for sure. Some character
are not properly escaped if you use raw sql.
On the other side, that is not related with the "query string too long
error". That seems top be limited to 65K
From connection.c
/* Indicate that we are sending a query to the backend */
if(strlen(query) > MAX_MESSAGE_LEN-2) {
self->errornumber = CONNECTION_MSG_TOO_LONG;
self->errormsg = "Query string is too long";
return NULL;
}
I'm not sure because I did it a few months ago, but the other limit (the
one on text fields) did not threw that error. Text fields were just
truncated. So that modif to the source doesn't correct the total query
string limit (and I wouldn't change the latter)
--
Rd
"Soft as the massacre of Suns
By Evening's Sabres slain"
[E.Dickinson]
______________________________________________________________________
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.
