[Users] avp_db_load

[Daniel-Constantin Mierla]

Hello Brandon,

what is the value you have in the column 'type' for this record?

Cheers,
Daniel

On 01/24/07 14:03, Brandon Armstead wrote:
> Hello Daniel,
>
>     I just tryed exactly this:
>
>         if(avp_db_load("$ru/username", "$avp(s:e911)"))
>         {
>                 avp_pushto("$ru", "$avp(s:e911)");
>         }
>
>         I even tried printing out the AVP after it should have been 
> loaded, once again NULL.  There is a row in usr_preferences, I have it 
> working with avp_db_query, however for the life of me can not get 
> avp_db_load to work?  I have a column 'username', a column 'domain', a 
> column 'attribute', a column 'type', and a column 'value'.  The 
> attribute is e911, the value is set, and the username is set, as well 
> as domain, although domain in this case should not matter.  I just 
> can't get it working..... any help is appreciated, thanks!
>
>
> On 1/24/07, *Daniel-Constantin Mierla* <daniel at voice-system.ro 
> <mailto:daniel at voice-system.ro>> wrote:
>
>     Hello,
>
>     did you get any error messages in syslog. Try:
>     avp_db_load("$ru/username", "$avp(s:e911)");
>
>     $rU is username, and $ru is R-URI from where to get the
>     username  (first
>     version should fire errors).
>
>     Cheers,
>     Daniel
>
>     On 01/23/07 19:59, Brandon Armstead wrote:
>     > Hello everyone,
>     >
>     >     I'm trying to load an avp from the database, now from my
>     > understanding I simply use the avp_db_load() function.  Now I
>     > previously setup my avp_table to be usr_preferences, now I'm
>     doing the
>     > following:
>     >
>     > route[5]
>     > {
>     >         xlog("L_INFO", "time [$Tf] method <$rm> r-uri <$ru> 2nd via
>     > <$hdr(via[1])>\n");
>     >
>     >         avp_db_load("$rU/username", "$avp(s:e911)");
>     >
>     >         xlog("L_INFO", "CURRENT AVP VALUE: $avp(s:e911)");
>     >
>     >         if(is_avp_set("$avp(s:e911)"))
>     >         {
>     >                 xlog("L_INFO", "CURRENT \$ru: $ru");
>     >                 avp_pushto("$ru", "$avp(s:e911)");
>     >                 xlog("L_INFO", "AFTER \$ru: $ru");
>     >         }
>     >
>     >         route(1);
>     > }
>     >
>     > For route 5, and I have a AVP row for 'e911' in the database,
>     with the
>     > username, domain, and the attribute set, the attribute ofcourse
>     being
>     > e911, type 0, and a value set.  However, I keep getting NULL
>     back for
>     > the AVP I'm trying to pull, does anyone care to explain what I'm
>     doing
>     > wrong?  Thanks.
>     >
>     > --
>     > Brandon Armstead
>     >
>     ------------------------------------------------------------------------
>     >
>     > _______________________________________________
>     > Users mailing list
>     > Users at openser.org <mailto:Users at openser.org>
>     > http://openser.org/cgi-bin/mailman/listinfo/users
>     >
>
>
>
>
> -- 
> Brandon Armstead