Cannot display Dates returned from Oracle Query - CF6.1

Hi,

We recently upgraded to 6.1 from MX. We have a simple query,

<cfquery name="qEvents" ...>
SELECT
EVENT_NAME,
EVENT_DATE
FROM
EVENTS
</cfquery>

<cfoutput query="qEvents"> #qEvents.EVENT_NAME#, #qEvents.EVENT_DATE# </cfquery>

The cfoutput only displays event_name and does not display event_date.
When I tried <CFDUMP var="#qEvents#">, the Dump displays the date column as "[empty string]".

I tried the same query through a query editor and the dates show up fine in the query results. Why is CF not able to recognize the existence of a date column?. It used to work fine when we were using 5.0 and MX.

Thanks
Greg
LVL 2
netuser1976Asked:
Who is Participating?
 
moduloCommented:
PAQed, with points refunded (30)

modulo
Community Support Moderator
0
 
netuser1976Author Commented:
Found Answer myself.
Unchecking "Return Timestamps as Strings" in the Advanced Settings for the datasource fixed the problem.

Thanks
Sathish
0
 
proceptCommented:
Hi,

you better have your points refunded. :-))

Chris
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.