someone is "101A" Main Street?
As well as #Form.PropertyAgentTelephoneNumber#. Shoudn't that be a text
datatype too? "555-555-1212" is text. As well as
#Form.PropertyAgentContactMobile#.
And therefore use ' around your vars............Access seems to better when
using ' sometimes.
-----Original Message-----
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 1:19 PM
To: CF-Talk
Subject: Simple UPDATE Stuff Driving Me Insane...
Hi guys,
I've got an update field where I'm. you guessed it, updating a table.
I keep getting:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Data type mismatch in criteria _expression_.
My code is below:
<CFQUERY NAME="AgentDetails" datasource="020">
UPDATE PropertyAgent
SET PropertyAgentCompanyName = '#Form.PropertyAgentCompanyName#',
PropertyAgentFlatNumberHouseName =
'#Form.PropertyAgentFlatNumberHouseName#', PropertyAgentStreetNumber =
#Form.PropertyAgentStreetNumber#, PropertyAgentStreetName =
'#Form.PropertyAgentStreetName#', PropertyAgentVillageTown =
'#Form.PropertyAgentVillageTown#', PropertyAgentCountyState =
'#Form.PropertyAgentCountyState#', PropertyAgentPostcodeZip =
'#Form.PropertyAgentPostcodeZip#', PropertyAgentCountry =
'#Form.PropertyAgentCountry#', PropertyAgentTelephoneNumber =
#Form.PropertyAgentTelephoneNumber#, PropertyAgentContactFirstName =
'#Form.PropertyAgentContactFirstName#', PropertyAgentContactSurname =
'#Form.PropertyAgentContactSurname#', PropertyAgentContactMobile =
#Form.PropertyAgentContactMobile#, PropertyAgentEmailAddress =
'#Form.PropertyAgentEmailAddress#'
WHERE PropertyAgentID = #Client.PropertyAgentID#
</CFQUERY>
My fields which are numbers are PropertyAgentStreetNumber,
PropertyAgentTelephoneNumber, PropertyAgentContactMobile.
When I change PropertyAgentContactMobile to
'#PropertyAgentContactMobile#' and correspondingly change the ACCESS
field to TEXT... the update works fine... so it seems like this is the
problem field as through tests, the others are fine.
Any ideas, this is bizarre? The field attributes seem the same for
PropertyAgentContactMobile as they are for the other numeric fields.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
