a date field in my table but I'm not updating that field.
>> <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>
-----Original Message-----
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: 02 February 2004 21:05
To: CF-Talk
Subject: RE: Simple UPDATE Stuff Driving Me Insane...
Nope, just don't update it. You only need to update the fields you want
to change, just ignore any you want to leave alone, so remove that line
from SQL statement.
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-----Original Message-----
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 12:36 PM
To: CF-Talk
Subject: RE: Simple UPDATE Stuff Driving Me Insane...
So even though I am not putting that into my UPDATE statement it still
needs something in there? What if I don't want to put something in
there. the date field is when they signed up. I don't want to change
it. does that mean I have to read it on the previous form (as hidden
text field) and then update it?
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 02 February 2004 20:18
To: CF-Talk
Subject: RE: Simple UPDATE Stuff Driving Me Insane...
well there is your answer, you are trying to put an empty value in that
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]
