XML DML

• paul.corujo

  SSCommitted

  Points: 1891

  More actions

  June 11, 2009 at 12:18 pm

  #133160

  Hi All,

  I am trying to change the value inside of a particular node. The xml is untyped. The following code runs but the value is not changed from true to false. Can somebody please help I'm pulling my hair out.:-)

  DECLARE @ConfigXML XML

  SELECT @ConfigXML = ConfigXML FROM AffiliateConfig WHERE AffiliateNo = 6 AND AffiliateConfigTypeID = 1

  if @ConfigXML.exist('/config/features/image/changenotification/enable') = 1

  begin

  SET @ConfigXML.modify('

  replace value of (/config/features/image/changenotification/enable[1]/text())[1]

  with "false"

  ')

  END

  Thanks so much!!!

  Paul

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  June 11, 2009 at 12:45 pm

  #1008194

  There must be something wrong in your XPath. This works fine:

  DECLARE @xml XML

  SELECT @xml = N'true'

  SET @xml.modify('

  replace value of (config/item/enabled/text())[1]

  with "false"

  ')

  SELECT @xml

  BTW: You don't need the IF part. If your "enabled" item does not exist nothing will be changed.

  Flo

• paul.corujo

  SSCommitted

  Points: 1891

  More actions

  June 11, 2009 at 1:01 pm

  #1008198

  Thanks so much for your help. I was overlooking something silly.

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  June 11, 2009 at 1:07 pm

  #1008205

  Glad I could help! 🙂