#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2001
    Location
    Germany
    Posts
    20
    Rep Power
    0

    Database transformation using xml


    Hi,
    Few days ago I transfer a full sql database from one sever to another. When doing so, first I write the data in an XML file using asp. In this case, I've just write into a file. Then I copy that xml file into another server.
    Now I read this file using asp XMLDom and submit data in the database.
    Throughout the process the following three characters cause some problem.

    &, '(quot) and a black block.

    These characters make the xml document illigal(not valid). My question is how can i handle this file when i am writing xml from database using asp or php script.

    Thank you
    rony
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    [b]
    <<
    My question is how can i handle this file when i am writing xml from database using asp or php script
    >>
    </b>

    i think when you write the data to xml, write that inside in CDATA section.or try to use a function to escape from these special characters in asp or php.
    SR -
    webshiju.com
    www.lizratechnologies.com

    "The fear of the LORD is the beginning of knowledge..."

IMN logo majestic logo threadwatch logo seochat tools logo