[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Malformed (??) XML and XML 2 SQL XSLT transformation
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
|
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
|