Hello Bogdan & Dave,<div><br></div><div>Yes. It works!</div><div><br></div><div><div>avp_db_load("$ruri/username", "s");</div><div>xlog("TEST: OFF LINE FORWARD TO: $avp(s:fwdoffline)\n");</div>
<div>xlog("TEST: BUSY FORWARD TO to: $avp(s:fwdbusy)\n");</div><div>xlog("TEST: CALL FORWARD TO : $avp(s:callfwd)\n");</div><br><div class="gmail_quote">On Tue, Aug 24, 2010 at 2:30 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi Sujeev,<br>
<br>
you can try it:<br>
<br>
- avp_db_load("$ruri/username", "a") (see<br>
<a href="http://www.opensips.org/html/docs/modules/1.6.x/avpops.html#id228513" target="_blank">http://www.opensips.org/html/docs/modules/1.6.x/avpops.html#id228513</a>)<br>
<br>
Regards,<br>
Bogdan<br>
<div><div></div><div class="h5"><br>
Sujeev wrote:<br>
> Hello List,<br>
> Please let me know how to load multiple attribute at one time. let<br>
> say. my "usr_preferences" table has 3 attribute for single user (e.g<br>
> fwdoffline,fwdbusy,callfwd). Now I load these 3 attributes at 3 times.<br>
> I want to reduce DB queries :)<br>
><br>
> I did this.<br>
><br>
> ------>8----<br>
> avp_db_load("$ruri/username", "$avp(s:)");<br>
> xlog("TEST: OFF LINE FORWARD TO: $avp(s:fwdoffline)\n");<br>
> xlog("TEST: BUSY FORWARD TO to: $avp(s:fwdbusy)\n");<br>
> xlog("TEST: CALL FORWARD TO : $avp(s:callfwd)\n");<br>
> ------>8----<br>
> and the result was<br>
><br>
> TEST : OFF LINE FORWARD TO: <null><br>
> TEST : BUSY FORWARD TO to: <null><br>
> TEST : CALL FORWARD TO : <null><br>
><br>
> P.S I followed<br>
> this <a href="http://www.mail-archive.com/users@openser.org/msg00589.html" target="_blank">http://www.mail-archive.com/users@openser.org/msg00589.html</a><br>
><br>
> Thank you,<br>
> Sujeev<br>
</div></div>> ------------------------------------------------------------------------<br>
<div class="im">><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
><br>
<br>
<br>
</div><font color="#888888">--<br>
Bogdan-Andrei Iancu<br>
OpenSIPS Bootcamp<br>
20 - 24 September 2010, Frankfurt, Germany<br>
<a href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a><br>
</font><div><div></div><div class="h5"><br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br></div>