[Users] Re: avp_db_query, NULL AVP?

Daniel-Constantin Mierla daniel at voice-system.ro
Wed Jan 24 11:35:51 CET 2007


could you send the config snippet that didn't work and the one that 
works to be able to troubleshoot.


On 01/23/07 22:00, Brandon Armstead wrote:
> Hello everyone,
>    I sorted this issue by changing the AVP naming scheme of mine over 
> to using AVP ints $avp(i: instead of strings...  Is there any 
> information on why the string AVP's would not work?  Thanks
> On 1/23/07, *Brandon Armstead* <brandon.armstead at gmail.com 
> <mailto:brandon.armstead at gmail.com>> wrote:
>     Hello everyone,
>         How is this possible?  I have the table usr_preferences, this
>     query runs fine: if(avp_db_query("SELECT value FROM
>     usr_preferences WHERE username = '$fU' AND attribute = 'e911'",
>     "$avp(i:911)")), in other words if I take the query that should be
>     constructed here, and is constructed here, and I run it in mysql
>     cli, I get back a result, however this function "does not" create
>     the AVP for me, no matter what I do, I run this, and I run
>     xlog("L_INFO", "the avp \$avp(i:911) equals.... $avp(i:911)");
>     however it says its NULL every single time, what am I doing wrong,
>     I've read and reread the AVP documentation over a million times,
>     however can not get this simply working, all help is appreciated,
>     thank you.
>     -- 
>     Brandon Armstead 
> -- 
> Brandon Armstead
> ------------------------------------------------------------------------
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users

More information about the sr-users mailing list