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>