No one ever says what database they are using :-) ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com
-----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:263138 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4