mysql to text in asp

[parames]

hello..
i'm using mysql database.. can anybody guide me how to take data from mysql database and put it in .txt file in asp...

thanks a lot..

rgds,
parames.s

 

[rhyswilliams]

I assume that youknpw how to open a connection and a recordset of the data that you want to write to a text file, so we'll skip to the final step..

Using the FSO (file system object collection):

sFullFilePath = 'full path to the text file on the server,
'you can make use of the server.mappath(...) command here
sOutput = 'enter the text that you want to save to the file

Set fs = CreateObject("Scripting.FileSystemObject&quot
Set fOutput = fs.CreateTextFile(sFullFilePath, True)
fOutput.Write(sOutput)
fOutput.Close

for more help go to the msdn search page and look for help on ASP and FSO:

http://search.microsoft.com/us/dev/default.asp