lhaluska
asked on
cfquery to excel only outputs 1 record
Here is my code to send my query to the excel file but only one shows up?
<cfquery name="qryAccessData"
datasource="NSKInfo">
SELECT a.systemName, a.systemNumber, a.numberofcpu, a.numberofio, a.ORG, a.division, b.director, a.type, a.comment, a.disposition, a.location, a.dateleftbldg, a.rmano, a.redeploy, a.lightson, a.footprint, a.srdate, a.srby, a.onallcount
FROM dbo.NSKSystemInfo a INNER JOIN dbo.director b ON a.director_id = b.director_ID
WHERE (a.onallcount = 'Yes')
order by a.systemname
</cfquery>
<!--- <CFOUTPUT><h1>#holder#</h1 ></CFOUTPU T> --->
<br>
<cfoutput query="qryAccessData">
<cfheader name="content-disposition" value="attachment;filename =allsyscou ntDump.xls ">
<cfcontent type="application/vnd.ms-e xcel">
<table border="1">
<tr>
<th>System Name</th>
<th>Sys/Order Number</th>
<th>Number of CPU</th>
<th>Number of IO</th>
<th>Type</th>
<th>Division</th>
<th>Director</th>
<th>ORG</th>
<th>Comment</th>
<th>Disposition</th>
<th>Location</th>
<th>Date Left Bldg</th>
<th>RMA& Number</th>
<th>Redeploy</th>
<th>Lights ON/OFF</th>
<th>Footprint</th>
<th>SRDate</th>
<th>SR BY</th>
</tr>
<tr>
<td>#qryAccessData.systemN ame#</td>
<td>#qryAccessData.systemN umber#</td >
<td>#qryAccessData.numbero fcpu#</td>
<td>#qryAccessData.numbero fio#</td>
<td>#qryAccessData.type#</ td>
<td>#qryAccessData.divisio n#</td>
<td>#qryAccessData.directo r#</td>
<td>#qryAccessData.ORG#</t d>
<td>#qryAccessData.comment #</td>
<td>#qryAccessData.disposi tion#</td>
<td>#qryAccessData.locatio n#</td>
<td>#qryAccessData.datelef tbldg#</td >
<td>#qryAccessData.rmano#< /td>
<td>#qryAccessData.redeplo y#</td>
<td>#qryAccessData.lightso n#</td>
<td>#qryAccessData.footpri nt#</td>
<td>#qryAccessData.srdate# </td>
<td>#qryAccessData.srby#</ td>
</tr>
</table>
</cfoutput>
<cfquery name="qryAccessData"
datasource="NSKInfo">
SELECT a.systemName, a.systemNumber, a.numberofcpu, a.numberofio, a.ORG, a.division, b.director, a.type, a.comment, a.disposition, a.location, a.dateleftbldg, a.rmano, a.redeploy, a.lightson, a.footprint, a.srdate, a.srby, a.onallcount
FROM dbo.NSKSystemInfo a INNER JOIN dbo.director b ON a.director_id = b.director_ID
WHERE (a.onallcount = 'Yes')
order by a.systemname
</cfquery>
<!--- <CFOUTPUT><h1>#holder#</h1
<br>
<cfoutput query="qryAccessData">
<cfheader name="content-disposition"
<cfcontent type="application/vnd.ms-e
<table border="1">
<tr>
<th>System Name</th>
<th>Sys/Order Number</th>
<th>Number of CPU</th>
<th>Number of IO</th>
<th>Type</th>
<th>Division</th>
<th>Director</th>
<th>ORG</th>
<th>Comment</th>
<th>Disposition</th>
<th>Location</th>
<th>Date Left Bldg</th>
<th>RMA& Number</th>
<th>Redeploy</th>
<th>Lights ON/OFF</th>
<th>Footprint</th>
<th>SRDate</th>
<th>SR BY</th>
</tr>
<tr>
<td>#qryAccessData.systemN
<td>#qryAccessData.systemN
<td>#qryAccessData.numbero
<td>#qryAccessData.numbero
<td>#qryAccessData.type#</
<td>#qryAccessData.divisio
<td>#qryAccessData.directo
<td>#qryAccessData.ORG#</t
<td>#qryAccessData.comment
<td>#qryAccessData.disposi
<td>#qryAccessData.locatio
<td>#qryAccessData.datelef
<td>#qryAccessData.rmano#<
<td>#qryAccessData.redeplo
<td>#qryAccessData.lightso
<td>#qryAccessData.footpri
<td>#qryAccessData.srdate#
<td>#qryAccessData.srby#</
</tr>
</table>
</cfoutput>
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.