|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
March 15th, 2005, 10:28 AM
|
|||
|
|||
|
Date Validation
I have an access DB with a field that I'm trying to insert a date into from a form. The field is datatype 'Date/Time' and the format is set as 'Long Date'. I inherited some code that looks like this
Form <INPUT TYPE="hidden" NAME="Submitted" SIZE="50" MAXLENGTH="50" VALUE="#NOW()#"> And uses CFUPDATE to update the record. This all works on windows 2k server and cf 4.5 but doesn't work using windows 2k3 server and cf 6.1. Any ideas how I can get this working again? Here's the error I'm getting Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. Last edited by iceperson : March 15th, 2005 at 10:31 AM. Reason: more information
|
|
#2
March 15th, 2005, 12:08 PM
|
|||
|
|||
|
Drop the cfupdate tag, and hand write the query.
|
|
#3
March 15th, 2005, 12:51 PM
|
|||
|
|||
|
Never use CFINSERT or CFUPDATE...two tags that should have never been.
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > Date Validation |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
