am new to asp, please help
i want to create a link, on clicking this link i want to download a sql query into text file.
i have done this as
/////////////////////////////////////////////////////////////
Response.Buffer = TRUE


Response.AddHeader "Content-Disposition","attachment;filename=text.txt"
Response.ContentType = "text/plain"
sql="select * from product_master"
set rs=con.execute(sql)

do until rs.eof
response.write(rs("product_name"))
response.write(rs("product_id"))
rs.movenext
loop
////////////////////////////////////////////////////////////////////
i want to display data from sql query as

product product_id
T-Shirt 101
Shirt 102

please help to do this. when i click on link it display File download dialog box and filename name "test.asp" instead of "text.txt" and then open in Macromedia Dreamweaver
Please help to do it in write way
Many Many Thank's in advanced

I believe you would need to use the filesystem object, fairly sure you cant to it the way you have illustrated.

;;on clicking this link i want to download a sql query into text file
do you mean the results of the query into a text file

;;and then open in Macromedia Dreamweaver
I'm sure you have a good reason for opening a text file in DW, this is where you lost me. There is allot of working examples in google, go here and try one of the many.

You need something like:
-----------------------
Set FileSysObject = CreateObject("scripting.filesystemobject")
Set MyFile = FileSysObject.createtextfile("c:\text.txt", True)

Open your DB HERE

MyFile.Write DataString 'Put watever you want in the file here.

MyFile.Close
--------------------------




Wind is your friend
Matt

Change the Content-Disposition header to inline, but keep the filename part - then it will display the text in the browser window
Response.AddHeader "Content-Disposition","inline;filename=text.txt"

I posted something about this curious behaviour a while ago http://p2p.wrox.com/topic.asp?TOPIC_ID=4005

rgds
Phil