>> Any thoughts anyone? yeah, lots.
the Jet db engine stores it's dates internally as mm/dd/yyyy, no matter what the Access GUI is set to. BUT it will accept the ISO date format. See my posts on this last week. http://www.cl.cam.ac.uk/~mgk25/iso-time.html see if you can send it dates in this format <cfset form.dateField = "04/05/2004"> <cfset theDate = LSDateFormat(form.dateField, "yyyy-mm-dd")> <cfoutput>#theDate#</cfoutput><br> ALSO, the Jet date delims are #'s (while SQLServer is ' ) where the date = #04/05/2004# which causes interesting problems with CF -----Original Message----- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: Wednesday, 14 July 2004 3:02 PM To: CFAussie Mailing List Subject: [cfaussie] 6.1 & CFUPDATE & Dates Hey all, I've got a coworker (not me!) who was happily using cfupdate in his app. I've upgraded the dev server to 6.1, and now his app breaks whenever it tries to pass through a date, with a 'datetype mismatch' error. It's running over an Access DB. Any thoughts anyone? Mark -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
