> 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]
