23 Jan
2007
23 Jan
'07
1:13 p.m.
Hi Brandon,
Perhaps if you use avp_db_query, you will have better luck.
The simple example below uses $fU instead of $rU and assumes that you
have a column in usr_preferences called "e911".
Hope this helps.
if (!avp_db_query("SELECT e911 FROM usr_preferences WHERE username =
'$fU'", "$avp(s:e911)")) {
xlog("L_NOTICE", "DATABASE ERROR avp_db_query() failed\n");
sl_send_reply("500", "Server Internal Error");
exit;
}
Regards,
Norm
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.
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users