ODBC Error

Started by Jillian Carrollalmost 24 years ago2 messagesgeneral
Jump to latest
#1Jillian Carroll
jillian@koskie.com

When I insert content from my WYSIWYG editor (eWebEditPro by Ektron) I
sometimes receive the following error. I don't believe the problem to be
ColdFusion related, as the problem cannot be replicated on MySQL (which I'd
really rather not have to use). I'm using Postgresql on RedHat. The
datatype is text, which I know is virtually unlimited. Anybody have this
happen before? I've also posted the CFQUERY from action.cfm below this
error.
Error Occurred While Processing Request

Error Diagnostic Information ODBC Error Code = 08S01 (Communication link

failure) Error while executing the query; Query string is too long The

error occurred while processing an element with a general identifier of

(CFQUERY), occupying document position (56:3) to (56:47) in the template

file /data/aliases/domain/sk/devel/admin/action.cfm. Date/Time: Tue Jun 18

17:20:49 2002 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)

Remote Address: 142.165.207.43 HTTP Referrer:

http://www.domain.ca/devel/admin/edit.cfm

*** *** ***

<CFQUERY NAME="q_gethtml" DATASOURCE="#DSN#">
INSERT INTO wysiwyg_tbl (edit_title, edit_html, edit_category)
VALUES ('#Trim(form.edit_title)#', '#Trim(form.myContent1)#',
'#Trim(form.edit_category)#')
</CFQUERY>

#2Hiroshi Inoue
Inoue@tpf.co.jp
In reply to: Jillian Carroll (#1)
Re: ODBC Error

Jillian Carroll wrote:

When I insert content from my WYSIWYG editor (eWebEditPro by Ektron) I
sometimes receive the following error. I don't believe the problem to
be ColdFusion related, as the problem cannot be replicated on MySQL
(which I'd really rather not have to use). I'm using Postgresql on
RedHat. The datatype is text, which I know is virtually unlimited.
Anybody have this happen before? I've also posted the CFQUERY from
action.cfm below this error.

Error Occurred While Processing Request

Error Diagnostic Information ODBC Error Code = 08S01 (Communication
link

failure) Error while executing the query; Query string is too long The

error occurred while processing an element with a general identifier
of

Server's version ?
And which version of ODBC driver are you using ?

regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/