How to get the rowcount of a resultset ????

[Former Member]

Hi ,

Is there anyway to get the rowcount of a resultset in bls without having to scan the resultset with a repeater? here , Resultset is the output of a sql query.

Thanks & Regards

Sreekanth

[Former Member]

Hi Srikanth,

I'm not sure if it does exist.Please share it here if you find one as it will be quite useful.

Regards,

Musarrat

[Former Member]

Srikanth,

There is property in IllumSQLQuery action called RowCount.

In the Link Editor you will find this.

Regards

Rupesh Bajaj

[Former Member]

Thanks Mussarat and Rupesh, for your replies...

Rupesh,

The Property RowCount is giving the rowcount ,which we defined in the Query Template but not the RowCount of the Result Set.

but i got a solution for this

solution works with the XPath Expression

The Sql Query Xpath is like

"someSQL_Query.Results{/Rowsets/Rowset/Row}"

for this query the number of rows in the result set would be ...

someSQL_Query.Results{<b>count(/Rowsets/Rowset/Row)</b>}

This gives the count without having to use the repeater

Thanks & Regards,

Sreekanth