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:356709
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
