25 Jan
2024
25 Jan
'24
5:29 p.m.
On 25 Jan 2024, at 06:34, Benoit Panizzon via sr-users sr-users@lists.kamailio.org wrote:
Hi List
Via sql_xquery I get a stacked xavp aka array.
I would like to store that stacked xavp into a hash table for later usage in other transactions. Is this possible?
You can always iterate through the XAVP array manually and perform your own data marshalling:
sql_xquery("db", "SELECT ...", "stuff");
$var(i) = 0;
while(defined $xavp(stuff[$var(i)])) { $sht(tbl=>$xavp(stuff[$var(i)]=>id)) = $xavp(stuff[$var(i)]=>otherval); $var(i) = $var(i) + 1; }
etc.
-- Alex
--
Alex Balashov
Principal Consultant
Evariste Systems LLC
Web: https://evaristesys.com
Tel: +1-706-510-6800