Do you know a tutorial/source for writing XPath Statements? -----Original Message----- From: tom dyson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 7:54 PM To: [EMAIL PROTECTED] Subject: Re: [cf-xml] CF_XMLQuery
Hi Tom Unfortunately the XMLQuery tag won't let you query complex XML documents very usefully with SQL - you'll need to use XPath to get to the data you want. As you probably know, to return all Transitions having a role of 'Owner' in your attached document you need the following XPath statement: Transitions/Transition[Roles/Role='Owner'] I'm interested in the idea of using SQL to query complex XML documents like yours, but I haven't thought of a good way to deal with multiple parent/child relationships... any suggestions gratefully received! Tom -----------------+ tom dyson t: +44 (0)1608 811870 m: +44 (0)7958 752657 http://torchbox.com > I'm intrigued with CF_XMLQuery and using SQL syntax for filtering data out of > an xml document. Attached is my attempt at pulling data out of an xml > document that is not working. The xml document is pretty detailed, it has > numerous levels of nested elements. How can I use SQL syntax to pull data > when the data I'm filtering against is several elements deep? For instance, > all transitions having a role of Owner. > > Thanks > > Tom Schreck > [EMAIL PROTECTED] > 817-252-4900 -----------------------+ cf-xml mailing list list: [EMAIL PROTECTED] admin: [EMAIL PROTECTED] home: http://torchbox.com/xml -----------------------+ cf-xml mailing list list: [EMAIL PROTECTED] admin: [EMAIL PROTECTED] home: http://torchbox.com/xml
