Yeah, that's the way I've been going about it as well. When I saw that line in the docs though, I though that'd make life even easier. Too bad...
Thanks, Ken Ferguson 214.636.6126 -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, September 04, 2006 12:34 PM To: CF-Talk Subject: Re: XML Document Object is NOT a struct? Can't say I have used the struct tags on XML docs but I do use the dot.notation to get the values etc. object.node.xmltext etc "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Ken Ferguson To: CF-Talk Sent: Mon Sep 04 18:24:50 2006 Subject: RE: XML Document Object is NOT a struct? Yeah, I did. I can dump the xml doc object and all. I can get at all the data by using xmlsearch... But the docs said it is represented as a structure, so I thought this would work: xmlD = xmlParse(xmldoc); writeOutput(isStruct(xmlD)); Oddly though, this outputs NO. Seems to me that if the XML Document Object was actually represented as a structure (as the docs say), then that should output YES. I guess it's not that big a deal. It's not too difficult to get all the data out of the document. It'd just be nice to have a simple XmlToQuery or an XmlToStruct function built in to make things even simpler. What would be even better is if the agency who created this damned XML schema had created a sql annotated schema which would actually work with SQL Server's XMLBulkLoad. Then I wouldn't have to fool with this at all and I could just load it all straight into the db. Thanks, Ken Ferguson 214.636.6126 -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, September 04, 2006 11:59 AM To: CF-Talk Subject: Re: XML Document Object is NOT a struct? You say it is a string? Have you ran it into ColdFusion with ParseXML? <cfset foo = ParseXML(yourXMLString)> Then perform the struct calls on foo? "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: [EMAIL PROTECTED] To: CF-Talk Sent: Mon Sep 04 16:43:52 2006 Subject: XML Document Object is NOT a struct? So, as per the docs for XMLNew, "An XML document object is represented in ColdFusion as a structure." This doesn't seem to be true though. I have an xml string I've parsed into an XML document object and I can't access it with any of the structure functions. I know there are other ways to access it and that's what I'm doing, but when I saw that line in the docs I got excited and was then disappointed when isStruct and structFind. falied to work. Am I insane, or is this just an error in the docs? Thanks, Ken Ferguson 214.636.6126 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251988 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4