Junk-T


replace value of(/node/sql:variable("@varname")/@Status)[1] with
"pass"'

gives me The XQuery syntax '/function()' is not supported.

Is it not supported





Re: replace value of (sq:variable("@variable")) with ""

Timothy Tim


If it is not supported what is the best way to update a specific node out of many based on certain criteria

like update Student Grade to A for Student node with name "John" and not any other, without having to use dynamic SQL.

Tim







Re: replace value of (sq:variable("@variable")) with ""

Timothy Tim

reproducing answer to this by Pohwan on another discussion alias. This is exactly what I wanted and it works if somebody else is in is same boat

*****************

Workaround,

/node/*[local-name()=sql:variable("@varname")]/@Status

instead of

/node/sql:variable("@varname")/@Status

--
Pohwan Han. Seoul.

**************







Re: replace value of (sq:variable("@variable")) with ""

Fahad

Thanks, that worked wonders for me