[OpenSIPS-Users] avp_db_load() & fetch multiple attribute at one time

[Sujeev]

Hello List,
Please let me know how to load multiple attribute at one time. let say. my
"usr_preferences" table has 3 attribute for single user (e.g
fwdoffline,fwdbusy,callfwd). Now I load these 3 attributes at 3 times. I
want to reduce DB queries :)

I did this.

------>8----
avp_db_load("$ruri/username", "$avp(s:)");
xlog("TEST: OFF LINE FORWARD TO: $avp(s:fwdoffline)\n");
xlog("TEST: BUSY FORWARD TO to: $avp(s:fwdbusy)\n");
xlog("TEST: CALL FORWARD TO : $avp(s:callfwd)\n");
------>8----
and the result was

TEST : OFF LINE FORWARD TO: <null>
TEST : BUSY FORWARD TO to: <null>
TEST : CALL FORWARD TO : <null>

P.S I followed this
http://www.mail-archive.com/users@openser.org/msg00589.html

Thank you,
Sujeev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100823/c1a68abe/attachment.htm