I am having a problem with getting my head how to do XML for a particular job. The XML is used to update a database. I can't use the XML as data, as data is received from more than one source.
This job requires that, when a new XML is received, database records are updated or added as required, but also, records not in the new XML dataset are removed from the database. What I currently do, is load all the data into a table 'a', then use MySQL to update the main table from table 'a'. But this doesn't seem to be using XML correctly - perhaps I am missing something? I have seen code which loads the XML into an array in memory, but I don't like that, it surely has XML size limitations. What techniques would others recommend? -- Pete Clark
