When used together, CFMX 6.1, Oracle 8.05, CreateODBCDateTime() error out. The same code works fine in CFMX 6.0. Can anyone verify?
The code in use is:
---
<cfquery name="getOperator" datasource="mva">
SELECT oper_name, (etc)
FROM mva_assignment
WHERE x_datetime_insert = #CreateODBCDateTime(url.dt)#
AND (etc)
</cfquery>
---
The exact error returned is:
---
Error Executing Database Query.
ORA-00904: invalid column name
---
The odd thing is that if the call is changed to CreateODBCDate(), it no longer errors out; the field is, however, a datetime field.
I'm not sure if this is a driver issue or a JDBC-ODBC Bridge issue, or some other issue entirely. I'm just looking for help for a colleague. Has anyone run into this?
--
Eric C. Davis
Programmer/Analyst I
Georgia Department of Transportation
Office of I.T. Applications
Web Applications Group
404.463.2860.199
[EMAIL PROTECTED]
