<div>
Take a look at <br />
<br />
<a href="http://www.perfectxml.com/articles/XML/ExportSQLXML.asp" rel="ugc">http://www.perfectxml.com/articles/XML/ExportSQLXML.asp</a><br />
<a href="http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=9336&FORUM_ID=5&CAT_ID=3&To" rel="ugc">http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=9336&FORUM_ID=5&CAT_ID=3&To</a><br />
<br />
see if it helps u !<br />
<br />
K'Rgds<br />
Anand
</div>


Take a look at

http://www.perfectxml.com/articles/XML/ExportSQLXML.asp [http://www.perfectxml.com/articles/XML/ExportSQLXML.asp]
http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=9336&FORUM_ID=5&CAT_ID=3&To [http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=9336&FORUM_ID=5&CAT_ID=3&To]

see if it helps u !

K'Rgds
Anand

<div>
use the logic &amp;&nbsp;create a SP for urself in ur SQL DB ... &amp;&nbsp;it shld create a XML file for u !
</div>


use the logic & create a SP for urself in ur SQL DB ... & it shld create a XML file for u !

<div>
<div class="content wysiwyg-content">
Recently I used ColdFusion's WDDX stuff to save the contents of forms to data files. I got to thinking... if I could create an XML document based on the returned recordset of a query, I could feed that XML document into my page layout program (Quark or Indesign) and get a jump-start on the repurposing of that content. This seems pretty simple, but after combing through the books I have, I can't catch on to what I need to do. <br />
<br />
Basically, our company has always been Internet based, so our products are all in our SQL database. The online catalog is served up through CF pages. We're now wanting to do a print catalog -- and all the data is there and with a page layout program's ability to handle XML, I know the answer is really close right now! &nbsp;=-) <br />
<br />
Has anyone done this before? How do I dump a recordset out into an XML file? 
</div>
</div>


Recently I used ColdFusion's WDDX stuff to save the contents of forms to data files. I got to thinking... if I could create an XML document based on the returned recordset of a query, I could feed that XML document into my page layout program (Quark or Indesign) and get a jump-start on the repurposing of that content. This seems pretty simple, but after combing through the books I have, I can't catch on to what I need to do. 

Basically, our company has always been Internet based, so our products are all in our SQL database. The online catalog is served up through CF pages. We're now wanting to do a print catalog -- and all the data is there and with a page layout program's ability to handle XML, I know the answer is really close right now!  =-) 

Has anyone done this before? How do I dump a recordset out into an XML file? 

Creating XML doc from database record set

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.