[Users] avp problems switching from 1.0.1 to 1.1.x

Bogdan-Andrei Iancu bogdan at voice-system.ro
Thu Jun 29 12:46:28 CEST 2006


Hi,

avp_db_load() will consider the psseudo variable as uuid, so both calls 
should do the same. Could you just check on mysql level what are the 
queries done in the two cases? (check the text log of mysql).

regards,
Bogdan


tele wrote:

> thanks!
> Ok i'm using the call-id and with the avp_db_query it works but with 
> avp_db_load not.
> this is what i have done:
>
> working:
>
>     avp_db_query("select value from usr_preferences where uuid='$ci' 
> and attribute='setup_time'","$avp(setup_time)");
>     avp_db_query("select value from usr_preferences where uuid='$ci' 
> and attribute='connect_time'","$avp(connect_time)");
>     avp_db_query("select value from usr_preferences where uuid='$ci' 
> and attribute='disconnect_time'","$avp(disconnect_time)");
>
> not working:
>
>      avp_db_load("$ci","$avp(setup_time)");
>      avp_db_load("$ci","$avp(connect_time)");
>      avp_db_load("$ci","$avp(disconnect_time)");
>





More information about the sr-users mailing list