Hello,
I am using ASP to run a SQL Server Stored procedure and then write the output to a text file using FSO. It is working fine. But I am having difficulty formatting the result in the text file.
I want the output to be "Unicode text format, tab delimited". Could anyone help me with this please. Do I need to use Response.Contenttype?
Below is a portion of the code which is both displaying the output on the screen and writing to the test file.
Thank you,
Shalini.
Set objTextStream = objFSO.OpenTextFile("C:\inetpub\ ,fsoForWriting, True)
Do While Not results.BOF and Not results.EOF
Response.Write (""&results("pagenumber"
&""
Response.Write (""&results("catdescription"
&""
objTextStream.Write ""&results("pagenumber"
&""
objTextStream.Write ""&results("catdescription"
&""
I am using ASP to run a SQL Server Stored procedure and then write the output to a text file using FSO. It is working fine. But I am having difficulty formatting the result in the text file.
I want the output to be "Unicode text format, tab delimited". Could anyone help me with this please. Do I need to use Response.Contenttype?
Below is a portion of the code which is both displaying the output on the screen and writing to the test file.
Thank you,
Shalini.
Set objTextStream = objFSO.OpenTextFile("C:\inetpub\ ,fsoForWriting, True)
Do While Not results.BOF and Not results.EOF
Response.Write (""&results("pagenumber"
Response.Write (""&results("catdescription"
objTextStream.Write ""&results("pagenumber"
objTextStream.Write ""&results("catdescription"