We help IT Professionals succeed at work.

URGENT: Coldfusion to XML

Medium Priority
231 Views
Last Modified: 2013-12-24
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.
Comment
Watch Question

<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#">

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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!!

Commented:
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

Commented:
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>
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.