and I'm wanting to process 160+ progranmme records to a mysql database table.
xml format as follows;
<programmes>
<programme>
<department>business</department>
<programme_title>bachelor of Business</programme_title>
etc...
</programme>
....
</programmes>
I have no problems with opening the datadirect link to the mysql 3.5 ODBC driver. I can create the .rdbxml file map the elements from the programmes.xml file to the created .rdbxml file, but when I run the xslt parser I get only one record showing in the preview and only one record written to the database?
How do i get all of the records into the database?
Do i need a doctype header in the xml source programmes file?
Do I have to have all the elements from the source xml file matching up with every table filed in the destination rdbms (mySQL), as I've only mapped a subset of elements from the source xml file to their relevant table field names?
The source 'programmes' xml file size is 302kb, is this to large to process, have tried cutting this into two parts but still get the same result?
The one programme record I get returned is half way down the source xml programme file list, i.e. it doesn't take the first record in the source programmes xml file?
Subject:DB-to-XML can only get one row insert at a time Author:jon wad Date:03 Oct 2006 05:51 AM
Thanks for this Ivan.
As a newbie to xsl is their a feature in stylus studio that will input these xslt functions via some sort of intelli-sense,
or a xpath function library lookup feature?
Subject:DB-to-XML can only get one row insert at a time Author:Ivan Pedruzzi Date:03 Oct 2006 11:04 AM
Jon,
In the mapping tool you just need to link the repeating element, in this case "PROGRAMME" to the destination repeating element, in this case "row", using the mouse right button, when the pop-up menu appears click "Create Repeatable link"