Malformed (??) XML and XML 2 SQL XSLT transformation

Play the video

Subject: Malformed (??) XML and XML 2 SQL XSLT transformation
From: Guillaume LECERF <guillaume.lecerf@xxxxxxxxxxxxxx>
Date: Fri, 14 Nov 2003 14:42:01 +0100

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

Current Thread

Re: Sablotron and PHP, (continued)
- Wendell Piez - Thu, 13 Nov 2003 19:24:32 -0500 (EST)
  - Paul Sleigh - Thu, 13 Nov 2003 20:22:12 -0500 (EST)
    - Jeni Tennison - Fri, 14 Nov 2003 03:42:27 -0500 (EST)
    - Michael Kay - Fri, 14 Nov 2003 08:20:42 -0500 (EST)
    - Guillaume LECERF - Fri, 14 Nov 2003 08:42:28 -0500 (EST) <=
    - J.Pietschmann - Fri, 14 Nov 2003 14:16:10 -0500 (EST)
    - Michael Kay - Fri, 14 Nov 2003 03:56:09 -0500 (EST)
- Cas Tuyn - Fri, 14 Nov 2003 03:06:25 -0500 (EST)
  - Andreas L. Delmelle - Fri, 14 Nov 2003 03:22:50 -0500 (EST)

<- Previous	Index	Next ->
RE: Sablotron and PHP, Michael Kay	Thread	Re: Malformed (??) XML and XM, J.Pietschmann
RE: Sablotron and PHP, Michael Kay	Date	RE: Dealing without global co, Robert Ogden
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >