Number of rows in the result of a sql fixed query

[matthias_prller]

Hello,

just a little question: How can I find out in a transaction if a result of a fixed query is empty or not? Do I realy have to take a "repeater" action block and look for the itemcount or is there an easier way?

thank you

Matthias.

[Former Member · Accepted solution]

Hey Matthias,

Yes you can. You can do the following in the LinkEditor under Expression:

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

Regards

Pedro

[agentry_src · Accepted solution]

Or

SQLActionblock.Results{boolean(/Rowsets/Rowset/Row)}

Mike