Re:Simple UPDATE Stuff Driving Me Insane...

[Stan Winchester]

Another thing I would do is analyze at the results of the query in the actual error message before you use CFQUERYPARAM and see what values are actually being passed, though I agree you should use CFQUERYPARAM, but not during debugging. You may find you are passing a text string rather than a number. You might also try val(PropertyAgentContactMobile).

>I would also recommend using CFQUERYPARAM.
>
>
>
><cfquery name="AgentDetails" datasource="020">
>UPDATE
> PropertyAgent
>SET
> PropertyAgentCompanyName = <cfqueryparam
>value="#Form.PropertyAgentCompanyName#" cfsqltype="CF_SQL_VARCHAR" />,
> PropertyAgentFlatNumberHouseName = <cfqueryparam
>value="#Form.PropertyAgentFlatNumberHouseName#"
>cfsqltype="CF_SQL_VARCHAR" />,
> PropertyAgentStreetNumber = <cfqueryparam
>value="#Form.PropertyAgentStreetNumber#" cfsqltype="CF_SQL_NUMERIC" />,
> .
> .
> .
>WHERE
> PropertyAgentID = <cfqueryparam value="#Client.PropertyAgentID#"
>cfsqltype="CF_SQL_NUMERIC" />
></cfquery>
>
>HTH,
>
>--Nathan

---

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

---