Re: [Users] avp_db_load

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@openser.org http://openser.org/cgi-bin/mailman/listinfo/users