getting column value as tag in xml
Posted: Mon Jul 24, 2006 5:38 am
Hi,
How can we get the column value as tag in xml?
For ex:
My 1st column name is COLOUR and its value is 'BLACK','WHITE' etc..,
2nd column name is LENGHT and its values is 1,2,....etc
I have to generate xml as
<BLACK>
<Value>
1
</Value>
</BLACK>
<WHITE>
<Value>
2
</Value>
<WHITE>
Could anyone suggest how to mention the path for this.
Thanks!
How can we get the column value as tag in xml?
For ex:
My 1st column name is COLOUR and its value is 'BLACK','WHITE' etc..,
2nd column name is LENGHT and its values is 1,2,....etc
I have to generate xml as
<BLACK>
<Value>
1
</Value>
</BLACK>
<WHITE>
<Value>
2
</Value>
<WHITE>
Could anyone suggest how to mention the path for this.
Thanks!