In my text field that the database received its info from is:
<cfinput name="PropertyAgentContactMobile" type="text"
value="#AgentDetails.PropertyAgentContactMobile#" size="25"
maxlength="20" required="no" class="formSTYLE2">
Where it says type="text" could I have put "number"? I have been
HTMLing for years but don't think I've ever seen number.??
-----Original Message-----
From: Stan Winchester [mailto:[EMAIL PROTECTED]
Sent: 02 February 2004 18:26
To: CF-Talk
Subject: Re:Simple UPDATE Stuff Driving Me Insane...
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]
- RE: Simple UPDATE Stuff Driving Me Insane... Robert Redpath
- RE: Simple UPDATE Stuff Driving Me Insane... Stuart Kidd
- RE: Simple UPDATE Stuff Driving Me Insane... Nathan Mische
- Re:Simple UPDATE Stuff Driving Me Insane... Stan Winchester
- RE: Simple UPDATE Stuff Driving Me Insane... Stuart Kidd
- RE: Simple UPDATE Stuff Driving Me Insane... Stuart Kidd
- RE: Simple UPDATE Stuff Driving Me Insane... Dave Watts
- RE: Simple UPDATE Stuff Driving Me Insane... Nathan Mische
- RE: Simple UPDATE Stuff Driving Me Insane... Ian Skinner
- RE: Simple UPDATE Stuff Driving Me Insane... Stuart Kidd
- RE: Simple UPDATE Stuff Driving Me Insane... Jerry Johnson
- RE: Simple UPDATE Stuff Driving Me Insane... Stuart Kidd