URGENT: Coldfusion to XML

Hi guys, i need code that when i get info from my database that it turns it into an xml file on the fly onto the server, so i can use this for rss feeds! i have a table called completed this would be the query that i would use to show my data:

<cfquery name="addcbook" datasource="mybook">
select * from completed
  </cfquery>

the table fields are: bname,date,bauthor,bookss,bidss

Thanks,

Ian.
LVL 2
IanaldoAsked:
Who is Participating?
 
mkishlineCommented:
<cfsavecontent variable="body">
      <cfoutput query="addcbook">
      <item>
            <bname>#bname#</bname>
            <date>#date#</date>
            <bauthor>#bauthor#</bauthor>
            <bookss>#bookss#</bookss>
            <bidss>#bidss#</bidss>
      </item>
      </cfoutput>
</cfsavecontent>

<cfoutput>#body#</cfoutput>
<cffile action="write" file="path_on_server.xml" output="#body#">
0
 
IanaldoAuthor Commented:
Hi know that kinda thing, thanks, but i need it to generate an xml file so that i can use the url of the generated xml file to allow for rss, so i need the whole xml generated, thanks!!
0
 
PluckaCommented:
mkishline,

What mk has provided would work for you.

Just build up the xml you require, then output the resulting variable (body in this example) at the end. No need to write it to the file.

<cfsavecontent variable="myXml">
    <?xml version="1.0" encoding="UTF-8"?>
    <root>
        <cfoutput query="addcbook">
        <item>
            <bname>#bname#</bname>
            <date>#date#</date>
            <bauthor>#bauthor#</bauthor>
            <bookss>#bookss#</bookss>
            <bidss>#bidss#</bidss>
        </item>
        </cfoutput>
    </root>
</cfsavecontent>

<cfoutput>#myXml#</cfoutput>

Regards
Plucka
0
 
pcaiooCommented:
Why the follow: complete code with dynamic variable all variable will show

<cfsetting enablecfoutputonly="yes">
<cfquery name="QueryCheck" datasource=#dbname#>
      SELECT      *
      From      ClientDB
</cfquery>
<cfsetting enablecfoutputonly="no">
<cfparam name="FileName" default="myfilename">      
<cfheader name="Content-Disposition" value="filename=#FileName#">
<xml id="QueryResult">
      <QueryRes><cfoutput query="QueryCheck">
            <QueryRow>
                  <RowCount>#QueryCheck.CurrentRow#</RowCount><cfloop list="#QueryCheck.Columnlist#" index="Fields">
                  <#Fields#>#HTMLeditFormat(evaluate("#Fields#"))#</#Fields#></cfloop>
            </QueryRow></cfoutput>
      </QueryRes>
</xml>
<cfabort>
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.