Create a new query from the original and use DateFormat to get the required
results. The logic can be somewhat like the following ...
<cfset qNew = QueryNew('myID, myDate')>
<cfloop query="qOrig">
<cfscript>
queryAddRow(qNew );
querySetCell(qNew, "myID", qOrig.myID );
querySetCell(qNew, "myDate",
DateFormat(qOrig.myDate,"dd/mm/yyyy") );
</cfscript>
</cfloop>
Ketan Jetty
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336985
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
