create XML file with ASP

[shank]

I have a stored procedure that creates XML content the way I want it using
FOR XML AUTO, ELEMENTS. At least when I run the query anyway. What I want is
to use that SP in an ASP page. When opened, I want a dialog box to pop up
with the option to open or save as... to the client's HDD. Here's my header
for the page. The recordset is below that. When I open the page, I get the
Save As.. I want, but no records are saved.

What I'm missing is how to deal with XML and the recordset thereof. It's
more of a feed that a recordset. How do I get that feed into a file on the
client machine?

<% Response.contenttype = "application/vnd.xml" %>
<% Response.AddHeader "Content-Disposition", "filename=Product.xml" %>

thanks

[Adrienne Boswell]

Gazing into my crystal ball I observed "shank" <sh***@tampabay.rr.com>
writing in news:eq**************@TK2MSFTNGP04.phx.gbl:

I have a stored procedure that creates XML content the way I want it
using FOR XML AUTO, ELEMENTS. At least when I run the query anyway.
What I want is to use that SP in an ASP page. When opened, I want a
dialog box to pop up with the option to open or save as... to the
client's HDD. Here's my header for the page. The recordset is below
that. When I open the page, I get the Save As.. I want, but no records
are saved.

What I'm missing is how to deal with XML and the recordset thereof.
It's more of a feed that a recordset. How do I get that feed into a
file on the client machine?

<% Response.contenttype = "application/vnd.xml" %>
<% Response.AddHeader "Content-Disposition", "filename=Product.xml" %>

thanks

You are probably using the wrong headers. You should be sending content
type text/xml .

--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

[shank]

"Adrienne Boswell" <ar****@yahoo.comwrote in message
news:Xn****************************@69.28.186.121. ..

Gazing into my crystal ball I observed "shank" <sh***@tampabay.rr.com>
writing in news:eq**************@TK2MSFTNGP04.phx.gbl:

>I have a stored procedure that creates XML content the way I want it
using FOR XML AUTO, ELEMENTS. At least when I run the query anyway.
What I want is to use that SP in an ASP page. When opened, I want a
dialog box to pop up with the option to open or save as... to the
client's HDD. Here's my header for the page. The recordset is below
that. When I open the page, I get the Save As.. I want, but no records
are saved.

What I'm missing is how to deal with XML and the recordset thereof.
It's more of a feed that a recordset. How do I get that feed into a
file on the client machine?

<% Response.contenttype = "application/vnd.xml" %>
<% Response.AddHeader "Content-Disposition", "filename=Product.xml" %>

thanks

You are probably using the wrong headers. You should be sending content
type text/xml .

--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share
======================

thanks! Good point - But that didn't help.