XQuery modify help

• olibbhq

  SSCarpal Tunnel

  Points: 4034

  More actions

  January 10, 2011 at 10:17 am

  #232029

  Hi,

  Thanks for your help in advance.

  I am trying to edit some xml

  <resRefDate>

  <refDate>20121218</refDate>

  <refDateType>

  <DateTypCd value="001" />

  </refDateType>

  </resRefDate>

  <resRefDate>

  <refDate>19820116</refDate>

  <refDateType>

  <DateTypCd value="002" />

  </refDateType>

  </resRefDate>

  UPDATE dbo._SSA SET xml_data.modify('replace value of (/metadata/dataIdInfo/idCitation/resRefDate/refDate/text())[1] with xs:string(sql:variable("@dTxtPubdate")) ') WHERE ID= @CustID

  UPDATE dbo._SSA SET xml_data.modify('replace value of (/metadata/dataIdInfo/idCitation/resRefDate/refDate/text())[2] with xs:string(sql:variable("@dTxtPubdate")) ') WHERE ID= @CustID

  At the moment the first refDate updates correctly but not the second. Could you please help with how I need to alter the modify so that I can change the values for both nodes.

  Many Thanks,

  Oliver

• olibbhq

  SSCarpal Tunnel

  Points: 4034

  More actions

  January 10, 2011 at 10:18 am

  #1271503

  I forgot to say that the node is preceeded by

  /metadata/dataIdInfo/idCitation/

  Many Thanks,

  Oliver