I had to do this the other day not sure if it's the best way but it worked:
<cfset local={} />
<cfquery datasource="central" name="local.query">
select name, expectedDate
from people
</cfquery>
<cfloop from="1" to="#local.query.recordCount#" index="i">
<cfset local.query.expectedDate[i] =
dateFormat(local.query.expectedDate[i],"dd mmm yyyy") />
</cfloop>
<cfdump var="#local.query#">
Paul
From: [email protected] [mailto:[email protected]] On Behalf
Of Steve Onnis
Sent: Monday, 15 December 2008 11:54 PM
To: [email protected]
Subject: [cfaussie] Changing the data type of a column
Is it possible to change the data type of a column using querySetCell() ?
I want to change a date value to a string dateFormat value but it seems to
be keeping the date object in there
Steve
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
