Re: cf query - wanting to set nls date

From: mike <hillmw_at_charter.net>
Date: 3 Aug 2005 10:02:43 -0700
Message-ID: <1123087798.926421.287990@o13g2000cwo.googlegroups.com>

Just so you all know what my solution was.

I know which fields are the date fields and therefore constructed a list of those called datelist.

<cfloop query="RptQry">

<cfloop list="#form.rptSelect#" index="i">
<cfif ListFind(date_list,#i#)>
<cfset rptval =

#DateFormat(RptQry[i][RptQry.CurrentRow],"mm/dd/yyyy")#>

<cfelse>
<cfset rptval =

#trim(XMLFormat(RptQry[i][RptQry.CurrentRow]))#>	</cfif>


	</cfloop>

</cfloop> Received on Wed Aug 03 2005 - 12:02:43 CDT