only gets filled on the insert when the user first joins up.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 02 February 2004 19:02
To: CF-Talk
Subject: Re: Simple UPDATE Stuff Driving Me Insane...
make sure ur formatting the dates correctly going into the date/time
fields of the db. access chokes if its empty or formatted wrong
99% of the time this is where that error message comes from
> 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]
