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

[Bogdan-Andrei Iancu]

Hi Sujeev,

you can try it:

- avp_db_load("$ruri/username", "a") (see 
http://www.opensips.org/html/docs/modules/1.6.x/avpops.html#id228513)

Regards,
Bogdan

Sujeev wrote:
> 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
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   


-- 
Bogdan-Andrei Iancu
OpenSIPS Bootcamp
20 - 24 September 2010, Frankfurt, Germany
www.voice-system.ro