Thanks Dominic, that worked like a charm. I swear I tried that notation, but apparently I did not.
I tried a multi-record query and if you want the first record you would just add [1] to the second data. //data[1]/data[1]/data If you dont you return all the records in the first data[1]. Thanks again for the help! Chad -----Original Message----- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: Thursday, May 27, 2010 4:33 AM To: cf-talk Subject: Re: XPATH Tested on CF8, this will give you an array of the ProductionStatus column elements: //data[1]/data/data This works for your example but may need tweaking depending on the format of other results of course. Would like to see what it looks like with more than one result / column. Dom On 27 May 2010 04:31, Mark Mandel <mark.man...@gmail.com> wrote: > > Chad, > > There is a great discussion of exactly this issue here: > > http://www.bennadel.com/blog/494-Stripping-XML-Name-Spaces-And-Node-Prefixes-From-ColdFusion-XML-Data-To-Simplify-XPath-.htm > > Basically - xpath and namespaces are a pain in cf. > > Check the comments of the blog post, they offer a good number of good > ideas. > > Mark > > On Thu, May 27, 2010 at 3:06 AM, Chad Gray <cg...@careyweb.com> wrote: > > > > > Can someone help me figure out the XPATH of the node that contains DISK > > SENT? > > > > Thanks! > > Chad > > > > <?xml version="1.0" encoding="UTF-8"?> > > <soapenv:Envelope xmlns:soapenv=" > http://schemas.xmlsoap.org/soap/envelope/"; > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" > > http://www.w3.org/2001/XMLSchema-instance";> > > <soapenv:Body> > > <ns1:jobStatusResponse soapenv:encodingStyle=" > > http://schemas.xmlsoap.org/soap/encoding/"; xmlns:ns1=" > > http://DefaultNamespace";> > > <jobStatusReturn xsi:type="ns2:QueryBean" xmlns:ns2=" > > http://rpc.xml.coldfusion";> > > <columnList soapenc:arrayType="xsd:string[1]" xsi:type="soapenc:Array" > > xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/";> > > <columnList xsi:type="xsd:string">PRODUCTIONSTATUS</columnList> > > </columnList> > > <data soapenc:arrayType="xsd:anyType[][1]" xsi:type="soapenc:Array" > > xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/";> > > <data soapenc:arrayType="xsd:anyType[1]" xsi:type="soapenc:Array"> > > <data xsi:type="soapenc:string">DISK SENT</data> > > </data> > > </data> > > </jobStatusReturn> > > </ns1:jobStatusResponse> > > </soapenv:Body> > > </soapenv:Envelop > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334036 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
