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)");