Once the data is pulled out of the database, you can get the meta data form the query:
GetMetaData( retrieved_data ) Take a look at that. ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Thursday, December 07, 2006 10:09 AM To: CF-Talk Subject: Determine database field type I have an export for excel button, using the code below. The problem is that dates aren't formatted as dates and I'd like to correct that. The first step would be to find out what type of field I am working with. I am don't know how to do that. Then I'll have to figure out how to make it a date field for excel. Any comments are welcome - thanks! <cfsetting showdebugoutput="No"> <cfoutput> <cfheader name="Content-Disposition" value="inline; filename=#db_table#.xls"> </cfoutput> <cfcontent type="application/msexcel"> <cfset column_ar = listToArray(retrieved_data.columnlist)> <table border="1" cellspacing="0" cellpadding="0"> <tr> <cfset column_ar = listToArray(retrieved_data.columnlist)> <cfloop from="1" to="#arrayLen(column_ar)#" index="ii"> <cfset content = column_ar[ii]> <td bgcolor="##CBE4F4"><cfoutput>#content#</cfoutput></td> </cfloop> </tr> <cfoutput query="retrieved_data"> <tr> <cfloop list="#retrieved_data.columnlist#" index="col"> <cfset content = retrieved_data[col][currentRow]> <td>#content#</td> </cfloop> </tr> </cfoutput> </table> -- Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
