<div>
Found Answer myself.<br />
Unchecking &quot;Return Timestamps as Strings&quot; in the Advanced Settings for the datasource fixed the problem.<br />
<br />
Thanks<br />
Sathish
</div>


Found Answer myself.
Unchecking "Return Timestamps as Strings" in the Advanced Settings for the datasource fixed the problem.

Thanks
Sathish

<div>
Hi,<br />
<br />
you better have your points refunded. :-))<br />
<br />
Chris<br />

</div>


Hi,

you better have your points refunded. :-))

Chris


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
We recently upgraded to 6.1 from MX. We have a simple query,<br />
<br />
&lt;cfquery name=&quot;qEvents&quot; ...&gt;<br />
SELECT<br />
EVENT_NAME,<br />
EVENT_DATE<br />
FROM<br />
EVENTS<br />
&lt;/cfquery&gt;<br />
<br />
&lt;cfoutput query=&quot;qEvents&quot;&gt; #qEvents.EVENT_NAME#, #qEvents.EVENT_DATE# &lt;/cfquery&gt;<br />
<br />
The cfoutput only displays event_name and does not display event_date. <br />
When I tried &lt;CFDUMP var=&quot;#qEvents#&quot;&gt;, the Dump displays the date column as &quot;[empty string]&quot;.<br />
<br />
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.<br />
<br />
Thanks<br />
Greg
</div>
</div>


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

Cannot display Dates returned from Oracle Query - CF6.1

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.