Re: so what am I doing wrong?

[Josh]

try this:

<cfquery name="qData" datasource="moteladam_moteladam_com">
   update data
   set data = "" value="#form.EditorDefault#"
cfsqltype="cf_sql_varchar">      
   where nav_id = #form.nav_id#
</cfquery>

HTH,

Josh

---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts



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
>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---