MODIFYING XML

• LeeLuv

  Mr or Mrs. 500

  Points: 588

  More actions

  February 8, 2010 at 12:57 am

  #96953

  Hi!!!!

  I will like to update this XML :

  <Root xmlns="http://WWW.BLUEFISH.CO.ZA/FORMS/">

  <INFORMATION>

  <Names>Scott</Names>

  <Surname>King</Surname>

  </INFORMATION>

  </Root>

  To change this address("http://WWW.BLUEFISH.CO.ZA/FORMS/">) to lowercase and I have 7000 rows to update

  Please Help!!!!!

• sadashiv.gosavi 65550

  Newbie

  Points: 5

  More actions

  June 9, 2011 at 1:15 am

  #1336055

  export the table to excel sheet.

  use excel function - "LOWER" to change that url column.

  again import the updated excel sheet to the database in the dummy table and update from dummy to original.

  See whether this helps.

• Iulian -207023

  SSCertifiable

  Points: 7639

  More actions

  June 9, 2011 at 2:11 am

  #1336077

  What is the DML of the table?

  Regards,

  Iulian