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>
----- Original Message -----
From: Jochem van Dieten
To: CF-Talk
Sent: Saturday, January 24, 2004 11:30 AM
Subject: Re: so what am I doing wrong?
Jochem van Dieten wrote:
> Daniel Farmer wrote:
>>
>> <cfquery datasource="moteladam_moteladam_com">
>> update data
>> set data = "" value="#form.EditorDefault#" cfsqltype="cf_sql_varchar">
>> where nav_id = #form.nav_id#
>> </cfquery>
>>
>> ERROR
>>
>> ODBC Error Code = S1104 (Invalid precision value)
>>
>> [Microsoft][ODBC Microsoft Access Driver]Invalid precision value
>
> Varchar fields are limited to 255 chars in Access.
And apart from that, data is a reserved word in SQL. Access
doesn't seem to mind for now, but you might wish to consider
changing that.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
