RE: [CFCDev] OT: CFMX 6.1, Oracle 8.05, CreateODBCDateTime()

[Davis, Eric]

Title: Message

The code is never missing pound signs.

 

The exact same code - no changes at all - worked just fine under 6.0.

 

Under 6.1, the difference between working and not working is whether we evaluate a #CreateODBCDate(foo)# or a #CreateODBCDateTime(foo)# in the query.

 

If I've failed to explain this clearly, please accept my apology.

 

--
Eric C. Davis
Programmer/Analyst I
Georgia Department of Transportation
Office of I.T. Applications
Web Applications Group
404.463.2860.199
[EMAIL PROTECTED]

-----Original Message-----
From: Brad Howerter [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 10:37 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [CFCDev] OT: CFMX 6.1, Oracle 8.05, CreateODBCDateTime()

I tried it, and I get the opposite result from what you get.

 

This query works okay:

<cfset foo = now()>
<cfquery name="rs" datasource="#request.dsn.select#">
 SELECT * FROM DUAL WHERE SYSDATE - 1 < #createODBCDate(foo )#
</cfquery>

 

But this one returns invalid column name (no pound signs around the createODBCDate function:

<cfset foo = now()>
<cfquery name="rs" datasource="#request.dsn.select#">
 SELECT * FROM DUAL WHERE SYSDATE - 1 < createODBCDate(foo )
</cfquery>

 

This is what I'd expect.

-----Original Message-----
From: Brad Howerter [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 8:22 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [CFCDev] OT: CFMX 6.1, Oracle 8.05, CreateODBCDateTime()

What does #CreateODBCDateTime(url.dt)# evaluate to?

-----Original Message-----
From: Davis, Eric [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 7:35 AM
To: [EMAIL PROTECTED]
Subject: [CFCDev] OT: CFMX 6.1, Oracle 8.05, CreateODBCDateTime()

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(url.dt ), 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]