Xlat iterate over sql result

15 Dec 2012

      Hi,

is there some way how to iterate over xlat sql query result ?

For example: I need send for user multiple ipv6 prefixes and they are 
stored in sql table and each prefix is represented by record in table.
Query return for example 4 rows.

update reply {

     Framed-IPv6-Prefix := "%{sql:SELECT network FROM ipv6_prefixes 
WHERE service = "user_service" }"
}

I am not able to find solution how to add all this records into reply.

Best Regards

Stanislav Lorenc