But did you change the datatype? - yes, I used cf_sql_varchar and cf_sql_char
How long is the string you are trying to insert - pretty long as it's the equiv to an html page,
And what is the definition of the field you are trying to update? - memo
----- Original Message -----
From: Jochem van Dieten
To: CF-Talk
Sent: Saturday, January 24, 2004 3:34 PM
Subject: Re: so what am I doing wrong?
Daniel Farmer wrote:
> a.. I gave the query a name and got the same error.
Queries are not required to have a name.
> b.. I removed the cfsqltype and got the same error.
>
> <cfquery name="qData" datasource="moteladam_moteladam_com">
> update data
> set data = "" value="#form.EditorDefault#">
> where nav_id = #form.nav_id#
> </cfquery>
But did you change the datatype? How long is the string you are
trying to insert and what is the definition of the field you are
trying to update?
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
