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 <[email protected]> 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 <[email protected]> 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:334033 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
