Your year is 20141 that is close to twenty thousand years in the future. -----Original Message----- From: Stephens, Larry V [mailto:steph...@iu.edu] Sent: Friday, September 06, 2013 8:33 AM To: cf-talk Subject: CreateODBCDate()
I'm stumped. This is an UPDATE query running on a CF8 server with an Access backend. (This is before I started using cfqueryparam and I haven't had a chance to update this code.) I've abbreviated the page. <cfparam name="FORM.DuesExpire" default=""> In the query: DuesExpire = <cfif len(FORM.DuesExpire) EQ 0>NULL<cfelse>#CreateODBCDate(FORM.DuesExpire)#</cfif>, This has been working. I'm using cftry. Here's the message it sent me: Detail: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'd '20141-04-30'}' It shows the query: ..., DuesExpire = {d '20141-04-30'}, ... I tried a test, thinking that the FORM value was malformed (it's set by the program, not manually entered): <cfset x = '20141/04/01'> <cfoutput>#CreateODBCDate(x)#</cfoutput> That throws: 20141/04/01 is an invalid date or time string. This implies to me that an error would have been thrown by the attempt to create the date via CreateODBCDate, but it looks to me like the function created a malformed ODBC date and the program choked when it tired to insert that into the table. Am I missing something? Any suggestions what happened? Larry Stephens ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm