Parsing XML in CF5
I have a task where I'll need to parse incoming XML (SOAP) documents in CF5. I'll probably want to create structs containing the data to then be placed into database tables. What tools do I have at my disposal in CF5 running on Windows 2000 Server Standard and IIS5? If nothing is available natively, what third party tools, CFX tags, etc. are available? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198469 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Parsing XML in CF5
What are the chances of moving up to CFMX? Jim McAtee wrote: I have a task where I'll need to parse incoming XML (SOAP) documents in CF5. I'll probably want to create structs containing the data to then be placed into database tables. What tools do I have at my disposal in CF5 running on Windows 2000 Server Standard and IIS5? If nothing is available natively, what third party tools, CFX tags, etc. are available? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198473 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Parsing XML in CF5
It's a little loopy, but instantiating the Microsoft.XMLHTTP object will generally work fine for accessing web services. The good thing is that the object you fill with XML can respond to XPath expressions as well ([yourXMLObject].selectNodes([XPath_statement]), from which you can pretty quickly fill a struct. It's not pretty, but it does work. - Jim Jim McAtee wrote: I have a task where I'll need to parse incoming XML (SOAP) documents in CF5. I'll probably want to create structs containing the data to then be placed into database tables. What tools do I have at my disposal in CF5 running on Windows 2000 Server Standard and IIS5? If nothing is available natively, what third party tools, CFX tags, etc. are available? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198474 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Parsing XML in CF5
Try the custom tag SOXML. It works pretty well. I used it on a couple of sites that parsed search results from Google, and others that parsed News Feeds, and some that parsed Amazon product info and then passed them into DB tables. It worked extremely well in all those cases. Those were all a couple of years ago and those sites have been running fine since. I haven't used for a couple of years, though, so I'm a bit rusty on the details. Here's the direct link to the download page on the MM Exchange. http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_usview=sn106vi ewName=Exchange%20Search%20Detailsauthorid=33595785page=0scrollPos=0subc atid=0snid=sn106itemnumber=0extid=1003618catid=0avm=1 HTH Ali -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 11:50 AM To: CF-Talk Subject: Parsing XML in CF5 I have a task where I'll need to parse incoming XML (SOAP) documents in CF5. I'll probably want to create structs containing the data to then be placed into database tables. What tools do I have at my disposal in CF5 running on Windows 2000 Server Standard and IIS5? If nothing is available natively, what third party tools, CFX tags, etc. are available? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198498 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Parsing XML in CF5
A set of basic XML tags is available gere too: http://www.cfdev.com/xml/ -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Saturday, 12 March 2005 5:01 To: CF-Talk Subject: RE: Parsing XML in CF5 Try the custom tag SOXML. It works pretty well. I used it on a couple of sites that parsed search results from Google, and others that parsed News Feeds, and some that parsed Amazon product info and then passed them into DB tables. It worked extremely well in all those cases. Those were all a couple of years ago and those sites have been running fine since. I haven't used for a couple of years, though, so I'm a bit rusty on the details. Here's the direct link to the download page on the MM Exchange. http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_usview=sn106vi ewName=Exchange%20Search%20Detailsauthorid=33595785page=0scrollPos=0subc atid=0snid=sn106itemnumber=0extid=1003618catid=0avm=1 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198524 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
