in reply to Copy XML file, write new attributes and move the old files.

What is the schema for the XMLelementen table ?
poj

Replies are listed 'Best First'.
Re^2: Copy XML file, write new attributes and move the old files.
by Nevamonk (Novice) on Jan 27, 2015 at 08:55 UTC

    id (prim key, auto increment)

    name (VARCHAR(255)

      In that case, here's a working script to demonstrate the basics of what I think you are trying to do. poj
        thats it!

        You are indeed a wise monk sir, thanks alot!

        there are just 2 things i need to alter.

        First of all, the files are read from a directory, so i'd have to have that readXmlDir sub, and second, It's not the database that needs updating, its the file nodes that need their attribute changed so it matches with the database. This is because we get XML from different servers and they all have their own ID's for the Element names.

        other then that, this is exactly what i was looking for.