Skip to Content
0
Former Member
Jun 28, 2007 at 10:31 AM

xMII BLS Usage

17 Views

Hi All,

I have a xml file as big as this :-

<?xml version="1.0" encoding="UTF-8"?><Rowsets DateCreated="2007-06-28T15:50:44" EndDate="2007-06-28T15:50:43" StartDate="2007-06-28T14:50:43" Version="11.5.1"><Rowset><Columns><Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/><Column Description="Bucket brigade item." MaxRange="0" MinRange="0" Name="Simulation_Items.Bucket_Brigade.REC1" SQLDataType="12" SourceColumn="Simulation Items.Bucket Brigade.REC1"/></Columns><Row><DateTime>2007-06-28T15:50:43</DateTime><Simulation_Items.Bucket_Brigade.REC1>Idle</Simulation_Items.Bucket_Brigade.REC1></Row></Rowset><Rowset><Columns><Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/><Column Description="Bucket brigade item." MaxRange="0" MinRange="0" Name="Simulation_Items.Bucket_Brigade.REC2" SQLDataType="12" SourceColumn="Simulation Items.Bucket Brigade.REC2"/></Columns><Row><DateTime>2007-06-28T15:50:43</DateTime><Simulation_Items.Bucket_Brigade.REC2>Idle</Simulation_Items.Bucket_Brigade.REC2></Row></Rowset><Rowset><Columns><Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/><Column Description="Bucket brigade item." MaxRange="0" MinRange="0" Name="Simulation_Items.Bucket_Brigade.REC3" SQLDataType="12" SourceColumn="Simulation Items.Bucket Brigade.REC3"/></Columns><Row><DateTime>2007-06-28T15:50:43</DateTime><Simulation_Items.Bucket_Brigade.REC3>Running</Simulation_Items.Bucket_Brigade.REC3></Row></Rowset><Rowset><Columns><Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/><Column Description="Bucket brigade item." MaxRange="0" MinRange="0" Name="Simulation_Items.Bucket_Brigade.REC4" SQLDataType="12" SourceColumn="Simulation Items.Bucket Brigade.REC4"/></Columns><Row><DateTime>2007-06-28T15:50:44</DateTime><Simulation_Items.Bucket_Brigade.REC4>Failure</Simulation_Items.Bucket_Brigade.REC4></Row></Rowset><Rowset><Columns><Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/><Column Description="Bucket brigade item." MaxRange="0" MinRange="0" Name="Simulation_Items.Bucket_Brigade.DEC1" SQLDataType="12" SourceColumn="Simulation Items.Bucket Brigade.DEC1"/></Columns><Row><DateTime>2007-06-28T15:50:44</DateTime><Simulation_Items.Bucket_Brigade.DEC1>Running</Simulation_Items.Bucket_Brigade.DEC1></Row></Rowset><Rowset><Columns><Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/><Column Description="Bucket brigade item." MaxRange="0" MinRange="0" Name="Simulation_Items.Bucket_Brigade.DEC2" SQLDataType="12" SourceColumn="Simulation Items.Bucket Brigade.DEC2"/></Columns><Row><DateTime>2007-06-28T15:50:44</DateTime><Simulation_Items.Bucket_Brigade.DEC2>Failure</Simulation_Items.Bucket_Brigade.DEC2></Row></Rowset><Rowset><Columns><Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/><Column Description="Bucket brigade item." MaxRange="0" MinRange="0" Name="Simulation_Items.Bucket_Brigade.DEC3" SQLDataType="12" SourceColumn="Simulation Items.Bucket Brigade.DEC3"/></Columns><Row><DateTime>2007-06-28T15:50:44</DateTime><Simulation_Items.Bucket_Brigade.DEC3>Failure</Simulation_Items.Bucket_Brigade.DEC3></Row></Rowset><Rowset><Columns><Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/><Column Description="Bucket brigade item." MaxRange="0" MinRange="0" Name="Simulation_Items.Bucket_Brigade.DR1" SQLDataType="12" SourceColumn="Simulation Items.Bucket Brigade.DR1"/></Columns><Row><DateTime>2007-06-28T15:50:44</DateTime><Simulation_Items.Bucket_Brigade.DR1>Idle</Simulation_Items.Bucket_Brigade.DR1></Row></Rowset><Rowset><Columns><Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/><Column Description="Bucket brigade item." MaxRange="0" MinRange="0" Name="Simulation_Items.Bucket_Brigade.DR2" SQLDataType="12" SourceColumn="Simulation Items.Bucket Brigade.DR2"/></Columns><Row><DateTime>2007-06-28T15:50:44</DateTime><Simulation_Items.Bucket_Brigade.DR2>Idle</Simulation_Items.Bucket_Brigade.DR2></Row></Rowset><Rowset><Columns><Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/><Column Description="Bucket brigade item." MaxRange="0" MinRange="0" Name="Simulation_Items.Bucket_Brigade.PKG1" SQLDataType="12" SourceColumn="Simulation Items.Bucket Brigade.PKG1"/></Columns><Row><DateTime>2007-06-28T15:50:44</DateTime><Simulation_Items.Bucket_Brigade.PKG1>Running</Simulation_Items.Bucket_Brigade.PKG1></Row></Rowset><Rowset><Columns><Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/><Column Description="Bucket brigade item." MaxRange="0" MinRange="0" Name="Simulation_Items.Bucket_Brigade.PKG2" SQLDataType="12" SourceColumn="Simulation Items.Bucket Brigade.PKG2"/></Columns><Row><DateTime>2007-06-28T15:50:44</DateTime><Simulation_Items.Bucket_Brigade.PKG2>Running</Simulation_Items.Bucket_Brigade.PKG2></Row></Rowset><Rowset><Columns><Column Description="DateTime" MaxRange="0" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime"/><Column Description="Bucket brigade item." MaxRange="0" MinRange="0" Name="Simulation_Items.Bucket_Brigade.PKG3" SQLDataType="12" SourceColumn="Simulation Items.Bucket Brigade.PKG3"/></Columns><Row><DateTime>2007-06-28T15:50:44</DateTime><Simulation_Items.Bucket_Brigade.PKG3>Failure</Simulation_Items.Bucket_Brigade.PKG3></Row></Rowset></Rowsets>

I want to retrieve the value of the second item of each {Rowset/Row}

that is, the values of the tag names Simulation_Items.Bucket_Brigade.REC1, Simulation_Items.Bucket_Brigade.REC2, Simulation_Items.Bucket_Brigade.REC3, and so on.

I have put a repeater on the Row, and trying to retrieve the second item, but I am able to get the value of the second item of only the first {Rowset/Row}.

Can anybody please help me with a logic as to how can I get the values of the second item of all the {Rowset/Row}???

Thanks in Advance,

Lipsa.