Read XML and input data into MySQL using Coldfusion

Posted on 2007-10-20
Last Modified: 2008-01-10

Does anybody have any examples how to import or read xml with Coldfusion and input the data into a table using Coldfusion?


Question by:brihol44
    1 Comment
    LVL 12

    Accepted Solution

    reading xml...

      URLToPull  = "";
     <cfhttp url="#URLToPull#" method="GET" timeout="15">
      XMLContent = trim(cfhttp.filecontent);
      XMLContent = XMLParse(XMLContent);

    output to see what you have i.e. cfdum at this point, then loop via each one if you have lots of data i.e.

     <cfloop from="1" to="3"  index="idx">
    xml content here

    within the output you could then output into a table however you like

    if you want an example on parsing xml here is a good link

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    PROBLEM:  How to open a cfwindow or run a function on double click of a cfgrid row. One of my clients wanted to be able to double click on a row item to get more detailed information about a transaction and to be able to modify the line items i…
    Today, I was working on some optimization and spam-stopping techniques when I encountered Ben Nadel's post to reduce spam feature using Math ( While this method is not o…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now