Classic ASP export to CSV generates blank 1st row -

Classic ASP export to CSV generates blank 1st row -

i have .asp page generates csv file download using info mysql database. issue is, first row of generated csv file blank. how eliminate blank 1st row output?

<%response.buffer = true response.clear response.contenttype = "text/csv" response.addheader "content-disposition", "attachment;filename=export.csv" struserid=request.querystring("uid") set con = server.createobject("adodb.connection") %> <!--#include file="databaseconnection.asp"--> <%con.open dsntest set rec1=con.execute ("select * orders receivedp = '0000-00-00 00:00:00' , pid = '" & struserid & "' order zipid asc")%> sep=; address;city;state;zip; <%while not rec1.eof strzipid = rec1("zipid") set rec3=con.execute ("select * zip zipcode = '" & strzipid & "'") %> <%=rec1("address")%>;<%=rec3("city")%>;<%=rec3("state")%>;<%=rec3("zipcode")%>; <%rec1.movenext wend rec1.close set rec1 = nil rec3.close set rec3 = nil con.close set con = nothing%>

bit of guess here, seek having vbs in single block of code , utilize vbcrlf add together line breaks need them - ie

<% con.open dsntest set rec1=con.execute ("select * orders receivedp = '0000-00-00 00:00:00' , pid = '" & struserid & "' order zipid asc") response.write "sep=;" & vbcrlf response.write "address;city;state;zip;" & vbcrlf while not rec1.eof strzipid = rec1("zipid") set rec3=con.execute ("select * zip zipcode = '" & strzipid & "'") response.write rec1("address")&";"&rec3("city")&";"&rec3("state")&";"&rec3("zipcode") & vbcrlf rec1.movenext wend 'etc

closing block of asp code , starting new 1 on next line adds line

csv asp-classic export-to-csv