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

Dave Singer dave.singer at wideideas.com
Mon Aug 23 18:57:45 CEST 2010


http://www.opensips.org/html/docs/modules/1.6.x/avpops.html#id228513 second
example.
 I believe the main problem is the ":" (colon)
I'm also not sure about your var $ruri.

This should work:
avp_db_load("$ru/username", "s");

On Mon, Aug 23, 2010 at 2:55 AM, Sujeev <support1 at meewadaya.com> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100823/5eaa5807/attachment.htm 


More information about the Users mailing list