Import XML Feed into Database

[Floyd7]

I have never worked with XML feeds. I need to retrieve a feed from a remote site and import it into a database.

Is there a way for me to create Coldfusion variables based on the XML tags and then insert them into a table? For example, if the XML feed has <question></question> tags, is there a way to parse the file and create a variable from the text between the <question> tags and name it #whatever#?

Thank you for any help you can give.

 

[philhege]

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_t-z_23.html

should get you started.

Many database applications already have import functionality. This task is better done using database tools directly. If you want to see or adjust the contents of the file prior to import, then you can use the CF XMLParse functions.

-----------
With business clients like mine, you'd be better off herding cats.