Re: ODBC Error

Hi !

It could be driver issue.

Anyhow, we had similar error with really long text input. You have limited /
extended text input for 65 000 chars in your cf-admin ? ( You are using CF5
linux ? )

Or could be that - I remember seeing somewhere - if your query in pgsql by
default, which your input is part of, exceeds 16 k it won't go ?


BR,

aarni



On Wednesday 19 June 2002 05:06 pm, you 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
>
> (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>