We recently upgraded to 6.1 from MX. We have a simple query,
<cfquery name="qEvents" ...>
<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.