Hi all,
I'd like to have your opinion about my problem :
I've got the following XML file :
<?xml version="1.0" encoding="iso8859-1" ?>
<Orders>
<Customer cust-id="C6272">
<Template Template-id="T37141">
<Fields FieldName="User Login ID">
<FieldValue>roger.moore</FieldValue>
</Fields>
<Fields FieldName="External Client ID">
<FieldValue>105</FieldValue>
</Fields>
<Fields FieldName="Job Docket">
<FieldValue>P377609</FieldValue>
</Fields>
<Fields FieldName="Order Date">
<FieldValue>10/14/2003</FieldValue>
</Fields>
<Fields FieldName="Order">
<FieldValue>O1084281</FieldValue>
</Fields>
<Fields FieldName="User Login ID">
<FieldValue>bernard</FieldValue>
</Fields>
<Fields FieldName="External Client ID">
<FieldValue>104</FieldValue>
</Fields>
<Fields FieldName="Job Docket">
<FieldValue>P377610</FieldValue>
</Fields>
<Fields FieldName="Order Date">
<FieldValue>10/16/2003</FieldValue>
</Fields>
<Fields FieldName="Order">
<FieldValue>O1084283</FieldValue>
</Fields>
</Template>
</Customer>
</Orders>
from what I want to generate :
INSERT INTO orders("User Login ID","External Client ID","Job Docket","Order
Date","Order") values("roger.moore","105","P377609","10/14/2003","O1084281");
INSERT INTO orders("User Login ID","External Client ID","Job Docket","Order
Date","Order") values("bernard","104","P377610","10/16/2003","O1084283");
with a XSLT transformer stylesheet.
Any idea ??
Thanks in advance,
Regards
--
Guillaume LECERF
Ingenieur Systemes d'Information / Responsable Production - Gage Interactive
http://www.activprint.com - +33 (0)2.31.06.67.62
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list