Are you using CF to create the XMl Document or are you reading in a XML document?
>>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. Why don't you create one to assist others? Teddy On 9/4/06, Ken Ferguson <[EMAIL PROTECTED]> wrote: > > 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:251987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4