Response.Write 1

[Swi]

I am successfully saving a text file from a recordset using response.write. See below:

        if formaction = "exportcsv" Then
          For Each F In rsLog.Fields
            Head = Head & "," & F.Name
          Next
          Head = Mid(Head,2) & vbCrLf
          rsLog.MoveFirst
          Response.ContentType = "text/plain"
          Response.AddHeader "Content-Disposition", "attachment;filename=test.txt"
          Response.Write Head & rsLog.GetString(2, , ",", vbCrLf, "")

The issue is that is also saves the whole HTML page. Am I doing something wrong?

Thanks.

Swi

 

[ChrisHirst]

Other than thinking that ASP can create and save a file client side, Nope.

Either:

Use The FileSystemObject to create the text file server side THEN present it as a download link.

Or use Response.BinaryWrite to stream the data to the useragent

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[Swi]

Thanks. I just used the FSO method.

Swi