SQL query missing only date data elements

[Jared13]

I just upgraded from CF 5 to CF 6.1 and am having an issue with any query that
pull a date from the database. I am using Oracle 9i as the database.

I am able to insert and update, but I can not pull any dates.


Note: In my data table all of the fields have data in them.

Here is an example of the query:

<cfquery name="Get_XTF" datasource="source">
SELECT XTF, Role, Email, Expires, attempt1, password as proper_pass
FROM source.Users
WHERE (login='#Login#')
</cfquery>

Note: that the "Expires" and "attempt1" fields are both date fields.
The code for the output is:

<cfoutput query="Get_XTF">
#XTF#<br>
#Role#<br>
#Email#<br>
#Expires#<br>
#attempt1#<br>
#proper_pass#
</cfoutput>

The output looks like such:
0
R
[email]me@email.com[/email]


newpassword_1


Thanks

[paross1]

Are you using an ODBC socket connection by any chance? If so, check the
advanced settings for your datasource in ColdFusion administrator and make sure
that the Return TimeStamp as String parameter is unchecked.

Phil