Subject: [xsl] Problem writing XSLT From: Mukul <mukulw3@xxxxxxxxx> Date: Thu, 12 Jun 2003 19:01:35 -0700 (PDT) |
Hello, I have an XML file in the form below. <trace> <LEVEL>FLOW</LEVEL> <TIME>2003-05-06 09:57:59:9567238</TIME> <TICKS>631878118799567238</TICKS> <COMPONENT>NS</COMPONENT> <SUBCOMPONENT>NS_SVC</SUBCOMPONENT> <ENTRY type="ProcEntry"> <Datum name="Method">Init</Datum> </ENTRY> </trace> <trace> <LEVEL>FLOW</LEVEL> <TIME>2003-05-06 09:58:00:2830701</TIME> <TICKS>631878118802830701</TICKS> <COMPONENT>NS</COMPONENT> <SUBCOMPONENT>NS_SVC</SUBCOMPONENT> <ENTRY type="ProcEntry"> <Datum name="Method">InitMgmt</Datum> </ENTRY> </trace> <trace> <LEVEL>FULL</LEVEL> <TIME>2003-05-06 09:58:00:2830701</TIME> <TICKS>631878118802830701</TICKS> <COMPONENT>NS</COMPONENT> <SUBCOMPONENT>NS_SVC</SUBCOMPONENT> <ENTRY type="ProcEntry"> <Datum name="Adapter">SA</Datum> <Datum name="Method">ServiceabilityAgent</Datum> </ENTRY> </trace> I need to make an XSL file in such a way so that resulted o/p will be in the following given below. <Query> <Data> insert into table(LEVEL,TIME,TICKS,COMPONENT,SUBCOMPONENT,Method) values('FLOW',2003-05-06 09:58:00:2830701,631878118799567238,NS,SVC,Init)</Data> <Data> insert into table(LEVEL,TIME,TICKS,COMPONENTS,SUBCOMPONENTS,Adapter,Method) values('FLOW',2003-05-06 09:58:00:2830701,631878118799567238,NS,SVC,SA,ServiceabilityAgent)</Data> </Query> Pls note -- 1 - each <trace> tag will generate a SQL in the corresponding <data> tag 2 - the value of columns of the SQL will come from <LEVEL>, <TIME>, <TICKS>, <COMPONENT>, <SUBCOMPONENT> and attribute values of <Datum> tag for e.g. Adapter and Method. The table name is a constant. 3 - values of table columns will be corresponding values of these tags I'll appreciate a response to the above problem.. Regards, Mukul __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] entity output, Passin, Tom | Thread | RE: [xsl] Problem writing XSLT, Jason |
Re: [xsl] Statistics - Calculating , Hugh Dixon | Date | [xsl] Shameless plug - Treebeard ve, Rob Rohan |
Month |