I have codes for saving in XLS, but need to change it in CSV format.
What do you need to change?
<cfsavecontent variable="results">
<cfcontent type="application/vnd.ms-excel">
<table>
<tr>
<th>employee</th>
<th>firstname</th>
<th>middlename</th>
<th>lastname</th>
<th>addr1</th>
<th>addr2</th>
<th>city</th>
<th>state</th>
<th>zip</th>
<th>hmphonenbr</th>
<th>datehired</th>
<th>termdate</th>
<th>department</th>
<th>departmen2</th>
<th>jobcode</th>
<th>jobdescrip</th>
<th>empstatus</th>
<th>emergconta</th>
<th>emergphone</th>
</tr>
<cfoutput query="GetTP2000">
<tr>
<td>#employee#</td>
<td>#firstname#</td>
<td>#middlename#</td>
<td>#lastname#</td>
<td>#addr1#</td>
<td>#addr2#</td>
<td>#city#</td>
<td>#state#</td>
<td>#zip#</td>
<td>#hmphonenbr#</td>
<td>#datehired#</td>
<td>#termdate#</td>
<td>#department#</td>
<td>#departmen2#</td>
<td>#jobcode#</td>
<td>#jobdescrip#</td>
<td>#empstatus#</td>
<td>#emergconta#</td>
<td>#emergphone#</td>
</tr>
</cfoutput>
</table>
</cfsavecontent>
</body>
</html>
<Cffile action="write" file="D:\ bla.....Get.xls" output="#results#">
I need to keep the column headers above.
tia
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247843
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
