Hi All
I want to convert stringList to xml when i am passing the string i am getting that whole string into one column as <item>
following is the output that i am getting when using the transaction
1)Text_Loader : where i am loading my encoded xml as string
2)StringListToxml : where i am converting string to xml
3)xml saver: looking for the decoded xml
but my output is follows . the output which i want is below the output which i am getting
<?xml version="1.0" encoding="UTF-8"?><Rowsets DateCreated="2007-03-09T12:40:20" EndDate="2007-03-09T12:40:20" StartDate="2007-03-09T12:40:20" Version="11.5.1"><Rowset><Columns><Column Description="Item" MaxRange="0" MinRange="0" Name="Item" SQLDataType="1" SourceColumn="Item"/></Columns><Row><Item><?xml version="1.0" encoding="UTF-8"?><Rowsets DateCreated="2007-01-09T17:42:38" EndDate="2007-01-02T16:11:14" StartDate="2007-01-02T16:11:14" Version="11.5.2">
<Rowset>
<Columns>
<Column Description="" MaxRange="1" MinRange="0" Name="TRANSACTION" SQLDataType="1" SourceColumn="TRANSACTION"/>
<Column Description="" MaxRange="1" MinRange="0" Name="USERID" SQLDataType="1" SourceColumn="USERID"/>
</Columns>
<Row>
<TRANSACTION>A</TRANSACTION>
<USERID>B</USERID>
</Row>
</Rowset>
<Rowset>
<Columns>
<Column Description="" MaxRange="100" MinRange="0" Name="CODE" SQLDataType="1" SourceColumn="CODE"/>
</Columns>
<Row>
<CODE>0012000000000021296</CODE>
</Row>
</Rowset>
</Rowsets></Item></Row></Rowset></Rowsets>
above code automatically got decoded to xml here in forum. it is in encoded form (with all & amp and ;,lt etc)
<b>should get</b>
<?xml version="1.0" encoding="UTF-8"?>
<Rowsets DateCreated="2007-01-09T17:42:38" EndDate="2007-01-02T16:11:14" StartDate="2007-01-02T16:11:14" Version="11.5.2">
<Rowset>
<Columns>
<Column Description="" MaxRange="1" MinRange="0" Name="TRANSACTION" SQLDataType="1" SourceColumn="TRANSACTION"/>
<Column Description="" MaxRange="1" MinRange="0" Name="USERID" SQLDataType="1" SourceColumn="USERID"/>
</Columns>
<Row>
<TRANSACTION>A</TRANSACTION>
<USERID>B</USERID>
</Row>
</Rowset>
<Rowset>
<Columns>
<Column Description="" MaxRange="100" MinRange="0" Name="CODE" SQLDataType="1" SourceColumn="CODE"/>
</Columns>
<Row>
<CODE>0012000000000021296</CODE>
</Row>
</Rowset>
</Rowsets>
Please reply as soon as possible
Regards
Namita
Message was edited by:
Namita Tripathi
Message was edited by:
Namita Tripathi