On 02/24/2010 11:20 AM, Daniel-Constantin Mierla wrote:
sqlops result is a matrix. You can access row and column by index. Or you look for something else?
I look for something that's transaction-persistent so that I can iterate over it in failure routes, and as far as I know $dbr() is not transaction-persistent.
Typical situation is a list of gateways in descending order of priority is retrieved from a database along with various other attributes. The only way I know to deal with that is to buffer the results from $dbr() into an array of AVPs and then cycle through them using a global AVP as an array index.