I'm primarily a VFP developer. For this particular project I had to go the pure ASP/VBS/ADO route. I'm almost finished amnd it's looking good.

One page generates an HTML report using ADO and VBS. After the report is shown, one of the choices the user gets is to download the data in an ASCII delimited file (that was the request, though I might add XML in the future).

I recurse the report page, using the same ADO logic, but instead of Response.Write to create an HTML table, I concatenate the data, delimited with commas into a variable.

Q: What's the syntax to send the variable contents as a download file? Obviously I do not want to Response.Write to the browser.

Q: Is the variable concatenation idea OK? I don't expect the dataset to be too big. Any other (better) choices?

TIA