I believe you can get that info back if you do "DESCRIBE table_name"
<!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Thursday, December 07, 2006 9: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:263136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
