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

2010-08-24 Thread Sujeev 
Hello Bogdan & Dave,

Yes. It works!

avp_db_load("$ruri/username", "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");

On Tue, Aug 24, 2010 at 2:30 PM, Bogdan-Andrei Iancu  wrote:

> 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: 
> > TEST : BUSY FORWARD TO to: 
> > TEST : CALL FORWARD TO : 
> >
> > P.S I followed
> > this http://www.mail-archive.com/us...@openser.org/msg00589.html
> >
> > Thank you,
> > Sujeev
> > 
> >
> > ___
> > Users mailing list
> > Users@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
>
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

2010-08-24 Thread 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: 
> TEST : BUSY FORWARD TO to: 
> TEST : CALL FORWARD TO : 
>
> P.S I followed 
> this http://www.mail-archive.com/us...@openser.org/msg00589.html
>
> Thank you,
> Sujeev
> 
>
> ___
> Users mailing list
> Users@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


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

2010-08-23 Thread Dave Singer 
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  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: 
> TEST : BUSY FORWARD TO to: 
> TEST : CALL FORWARD TO : 
>
> P.S I followed this
> http://www.mail-archive.com/us...@openser.org/msg00589.html
>
> Thank you,
> Sujeev
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

2010-08-23 Thread 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: 
TEST : BUSY FORWARD TO to: 
TEST : CALL FORWARD TO : 

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

Thank you,
Sujeev
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users