<a href="http://www.opensips.org/html/docs/modules/1.6.x/avpops.html#id228513">http://www.opensips.org/html/docs/modules/1.6.x/avpops.html#id228513</a> second example.<br> I believe the main problem is the ":" (colon)<br>
I'm also not sure about your var $ruri.<br><br>This should work:<br>avp_db_load("$ru/username", "s");<br><br><div class="gmail_quote">On Mon, Aug 23, 2010 at 2:55 AM, Sujeev <span dir="ltr"><<a href="mailto:support1@meewadaya.com">support1@meewadaya.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hello List,<div>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 :)</div>
<div><br></div><div>I did this.</div><div><br></div><div>------>8----</div><div><div>avp_db_load("$ruri/username", "$avp(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></div><div>------>8----</div><div>and the result was</div><div><br></div>
<div>
<div>TEST : OFF LINE FORWARD TO: <null></div><div>TEST : BUSY FORWARD TO to: <null></div><div>TEST : CALL FORWARD TO : <null></div></div><div><br></div><div>P.S I followed 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></div>
<div><br></div><div>Thank you,</div><div>Sujeev</div>
<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></blockquote></div><br>