I am working at some mailmerge functionality and am using some code that automatically outputs a query into a .xls file. The weird thing that is happening though is that the more items there are in the query the further down the page in the xls file it is created.
For example, running three different queries,
the first returned two items and the headers and then two rows of data started on line 29.
the second returned 0 rows of data and the headers are on row 11 (obviously with no rows of data below)
the third returned about 30 items and started on row ~200 (with headers and then data below)
I would like to see if i can get all the data to just output at the top of the xls file rather than hundreds of rows down.
Here is what I've got that is outputting the above:
<query name="GetInfo"> - The queries are not returning any blank lines when I run them from query analyzer (that was a thought I had that could be causing it but to no avail)
<cfheader name="content-disposition" value="inline;filename=ClientReport.xls">
<th>Address Line 1</th>
<th>Address Line 2</th>
Any ideas on why this may be happening and how to correct it would be very much appreciated.