I'd like to create (on demand) a .csv file from records in my db, then download the file to the client.
I think it would go like this:
(collect variables in asp, then)
set fs=server.createobject("scripting.filesystemobject")
set f=fs.createtextfile(server.mappath("/test.csv"),true)
f.writeline("<%=value1%>" & "," & "<%=value2%>")
f.writeline("<%=value3%>" & "," & "<%=value4%>")
f.close
<a href="http://www.mysite.com/test,csv">Download</a>
Does this make any sense?
Is there a cleaner way to do it?
I should probably create a unique name for the file to keep somebody from creating the file, then letting the link sit on their browser for awhile- they could get someone elses file.
I'd have to delete it after download.
How would I do that?
Thanks for any thoughts.
Dan
Topic Options
Post Options
Thanks(0)
