Get Number of rows from a sql query.

[Former Member]

I am reading data from a sql query in a BLS transaction and I would like to know the number of rows returned.

Is there an easy way to do this without looping through the table?

Thanks Jasper

[Former Member · Accepted solution]

Hi Jasper,

You can use the XPATH count function similar to this:

GetTagList.Results{count(/Rowsets/Rowset/Row)}

Kind Regards,

Diana Hoppe

[Former Member · Accepted solution]

Thanks Diana, that worked.

Edited by: Jasper Vander Velden on Sep 1, 2011 7:16 PM