October 30th, 2011, 08:07 PM
|
|
Registered User
|
|
Join Date: Oct 2011
Posts: 1
Time spent in forums: 31 m 5 sec
Reputation Power: 0
|
|
|
Using attribute value in the xml node as element/variable name
Hi XSL gurus,
Code:
<table name="ASSETS_TABLE" statement-type="INSERT">
<column name="ASSET_ID">string(/assets/asset/value())</column>
<column name="ASSET_VALUE">
<option name="VALUE_GREATER_THEN_0">/assets/asset > 0</option>
<option name="VALUE_LESS_THEN_0">/assets/asset < 0</option>
<option name="OTHERWISE">1</option>
</column>
<column name="ASSET_DESCRIPTION">string(/assets/asset/text())</column>
</table>
From the above XML, i need to get the values of the attributes (i.e name). For column and option nodes, how would you go about using a loop to get the value of the attribute and using it as an element name or a variable name and the value of the column node as value of the new element or variable.
So I'd want something like
Code:
<ASSET_VALUE>
<VALUE_GREATER_THEN_0>/assets/asset > 0</VALUE_GREATER_THEN_0>
<VALUE_LESS_THEN_0>/assets/asset < 0</VALUE_LESS_THEN_0>
<OTHERWISE>1</OTHERWISE>
</ASSET_VALUE>
<ASSET_DESCRIPTION>string(/assets/asset/text())</ASSET_DESCRIPTION>
Any help on this is really appreciated.
Thanks guys
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
