How can I take the results of a Query and save it as an Excel file?
This is what I though would work.
Thanks all!
<CFQUERY NAME="DIMS" DATASOURCE="DSTS">
SELECT END_ITEM_ROOT_PN, END_ITEM_SN
FROM DSTS.B_V_DSTS_ASSEMBLY
ORDER BY END_ITEM_ROOT_PN, END_ITEM_SN
</CFQUERY>
<cfcontent type="application/msexcel">
<CFOUTPUT QUERY="DIMS">#END_ITEM_ROOT_PN# #END_ITEM_SN#</CFOUTPUT>
Jim Ray
Delta Program NT Administrator
The Boeing Company
(714) 896-2038
Email: [EMAIL PROTECTED]
Website: http://deltaweb.lgb.cal.boeing.com/
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
