[Kamailio-Users] Storing nonscalar types (lists)

[Alex Balashov]

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.

-- 
Alex Balashov - Principal
Evariste Systems LLC

Tel    : +1 678-954-0670
Direct : +1 678-954-0671
Web    : http://www.evaristesys.com/