Hi everyone,
I am trying to parse this xml file below. I need the values of all c0, c1,
c2,c3,c4,c5,c6,c7,c8, c9 and c10. I have to make a loop to read all the values
and construct another xml document. Please let me know how can I do it. Below
is the xml file
<returnXml>
<methodStatus>
<statusType>success</statusType>
</methodStatus>
<parametersReturn>
<rowSet rowCount="17" columnCount="12">
<columnDefinitions collection="1"
objectType="columnDefinition">
<columnDefinition>
<columnHeading></columnHeading>
<columnName>iReferenceId</columnName>
<columnOrdinal>1</columnOrdinal>
<columnFlags>24</columnFlags>
<columnSize>4</columnSize>
<columnType>i4</columnType>
<columnPrecision>10</columnPrecision>
<columnScale>255</columnScale>
</columnDefinition>
<columnDefinition>
<columnHeading></columnHeading>
<columnName>iParameterId</columnName>
<columnOrdinal>2</columnOrdinal>
<columnFlags>24</columnFlags>
<columnSize>4</columnSize>
<columnType>i4</columnType>
<columnPrecision>10</columnPrecision>
<columnScale>255</columnScale>
</columnDefinition>
<columnDefinition>
<columnHeading></columnHeading>
<columnName>iSiteId</columnName>
<columnOrdinal>3</columnOrdinal>
<columnFlags>24</columnFlags>
<columnSize>4</columnSize>
<columnType>i4</columnType>
<columnPrecision>10</columnPrecision>
<columnScale>255</columnScale>
</columnDefinition>
<columnDefinition>
<columnHeading></columnHeading>
<columnName>iParentId</columnName>
<columnOrdinal>4</columnOrdinal>
<columnFlags>24</columnFlags>
<columnSize>4</columnSize>
<columnType>i4</columnType>
<columnPrecision>10</columnPrecision>
<columnScale>255</columnScale>
</columnDefinition>
<columnDefinition>
<columnHeading></columnHeading>
<columnName>vchParameterDesc</columnName>
<columnOrdinal>5</columnOrdinal>
<columnFlags>8</columnFlags>
<columnSize>50</columnSize>
<columnType>string</columnType>
<columnPrecision>255</columnPrecision>
<columnScale>255</columnScale>
</columnDefinition>
<columnDefinition>
<columnHeading></columnHeading>
<columnName>iAlternateLangId</columnName>
<columnOrdinal>6</columnOrdinal>
<columnFlags>120</columnFlags>
<columnSize>4</columnSize>
<columnType>i4</columnType>
<columnPrecision>10</columnPrecision>
<columnScale>255</columnScale>
</columnDefinition>
<columnDefinition>
<columnHeading></columnHeading>
<columnName>vchExtraData</columnName>
<columnOrdinal>7</columnOrdinal>
<columnFlags>104</columnFlags>
<columnSize>20</columnSize>
<columnType>string</columnType>
<columnPrecision>255</columnPrecision>
<columnScale>255</columnScale>
</columnDefinition>
<columnDefinition>
<columnHeading></columnHeading>
<columnName>vchCharacterCode</columnName>
<columnOrdinal>8</columnOrdinal>
<columnFlags>104</columnFlags>
<columnSize>20</columnSize>
<columnType>string</columnType>
<columnPrecision>255</columnPrecision>
<columnScale>255</columnScale>
</columnDefinition>
<columnDefinition>
<columnHeading></columnHeading>
<columnName>iSeqNum</columnName>
<columnOrdinal>9</columnOrdinal>
<columnFlags>24</columnFlags>
<columnSize>4</columnSize>
<columnType>i4</columnType>
<columnPrecision>10</columnPrecision>
<columnScale>255</columnScale>
</columnDefinition>
<columnDefinition>
<columnHeading></columnHeading>
<columnName>iAccessCode</columnName>
<columnOrdinal>10</columnOrdinal>
<columnFlags>24</columnFlags>
<columnSize>4</columnSize>
<columnType>i4</columnType>
<columnPrecision>10</columnPrecision>
<columnScale>255</columnScale>
</columnDefinition>
<columnDefinition>
<columnHeading></columnHeading>
<columnName>dtModifiedDate</columnName>
<columnOrdinal>11</columnOrdinal>
<columnFlags>24</columnFlags>
<columnSize>16</columnSize>
<columnType>dateTime</columnType>
<columnPrecision>23</columnPrecision>
<columnScale>3</columnScale>
</columnDefinition>
<columnDefinition>
<columnHeading></columnHeading>
<columnName>tiRecordStatus</columnName>
<columnOrdinal>12</columnOrdinal>
<columnFlags>24</columnFlags>
<columnSize>1</columnSize>
<columnType>i1</columnType>
<columnPrecision>3</columnPrecision>
<columnScale>255</columnScale>
</columnDefinition>
</columnDefinitions>
<rows collection="1" objectType="row">
<row>
<c0>1</c0>
<c1>101</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Billing</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>1</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>1</c0>
<c1>102</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Business</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>2</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>1</c0>
<c1>119</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Home</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>3</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>1</c0>
<c1>148</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Visiting</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>4</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>2</c0>
<c1>102</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Business</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>1</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>2</c0>
<c1>103</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Cellular</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>2</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>2</c0>
<c1>115</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Fax</c4>
<c5></c5>
<c6>FAX</c6>
<c7></c7>
<c8>3</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>2</c0>
<c1>119</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Home</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>4</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>2</c0>
<c1>339</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Pager</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>5</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>3</c0>
<c1>166</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Prospect</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>1</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>3</c0>
<c1>170</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Evaluation</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>2</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>3</c0>
<c1>186</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Reseller</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>3</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>3</c0>
<c1>299</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Lead</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>4</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>3</c0>
<c1>300</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Purchased</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>5</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>3</c0>
<c1>303</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Analyst</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>6</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>3</c0>
<c1>100314</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Contact</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>7</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
<row>
<c0>3</c0>
<c1>100325</c1>
<c2>1</c2>
<c3>0</c3>
<c4>Customer</c4>
<c5></c5>
<c6></c6>
<c7></c7>
<c8>8</c8>
<c9>1</c9>
<c10>2005-05-23 13:31:55</c10>
<c11>1</c11>
</row>
</rows>
</rowSet>
</parametersReturn>
<customData></customData>
</returnXml>
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h0lbnur/M=362131.6882499.7825260.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1124522458/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
