date field and its throwing an error, i guarantee it. if i am wrong tony
will pay u $100;)
> Maybe that could be part of the problem as there is a date field but it
> 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]
