I cannot for the life of me figure out how to parse out this value. I
have done this many times in the past, but for some reason I can't seem
to get this working today, hopefully somebody can show me where my error
is so I can stop pulling my hair out over it.

I have the following NDS document returned from a JDBC driver call to
the destination command processor:

<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20090520_1228" instance="HPF Upgraded Test"
version="3.5.4">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<jdbcut-parameters event-id="0" jdbc:number-of-params="2">
<jdbcaram/>
<jdbcaram/>
<jdbcaram jdbc:name="@Result" jdbcaram-type="INOUT"
jdbcosition="4" jdbc:sql-type="java.sql.Types.INTEGER">
<jdbc:value>-5</jdbc:value>
</jdbcaram>
<jdbcaram jdbc:name="@Status" jdbcaram-type="INOUT"
jdbcosition="5" jdbc:sql-type="java.sql.Types.CHAR">
<jdbc:value>The specified user to copy from was not be
found.</jdbc:value>
</jdbcaram>
</jdbcut-parameters>
<status event-id="0" jdbc:update-count="1" level="success">
<application>DirXML</application>
<module>HPF Upgraded Test</module>
<object-dn>\CHSIDMMCK\CHSMck\EMP\Active\rivey</object-dn>
<component>Subscriber</component>
</status>
</output>
</nds>


I need to peel out the second instance of jdbc:value where it has the
string "The specified user to copy from was not be found." (yes, the
creator of this stored procedure talks engrish good)

I toss the returned NDS document into the local variable JDBC-RESULT,
then try to run an xpath query to yank that value out but can't seem to
get it working. I have tried many flavors, my current iteration looks
like:

token-xpath("$JDBC-RESULT/jdbcaram[@jdbcosition='5']/jdbc:value")

which returns a blank string. Any ideas?


--
robertivey
------------------------------------------------------------------------
robertivey's Profile: http://forums.novell.com/member.php?userid=27938
View this thread: http://forums.novell.com/showthread.php?t=425836