[Users] AVPOPS: question about avp_db_query

[Klaus Darilion]

Daniel-Constantin Mierla wrote:
> Hello,
> 
> On 03/06/07 09:59, Papadopoulos Georgios wrote:
>> Hello,
>>  
>> Is there a way to load an integer value into an integer avp using 
>> avp_db_query? For example if in table usr_preferences I have 
>> value='15' and type=1, then using avp_db_load I get an avp with an int 
>> value of 15. Then I can use this int avp to check whether it is 
>> greater or less than some value. I am trying to do the same thing with 
>> avp_db_query but the avp that I get is a string.
> that's because in usr_preferences the values are stored in a string 
> column. If you make another table and store the value in an integer 
> column, then it will be stored as integer in AVP.
> 
> avp_db_query() takes the type of value from type of column.

Also with 1.1? I just tried avp_db_query() and load an integer column 
type from mysql into an AVP, but the AVP is always defined as string.

Any hints were I could have an error?

regards
klaus


> 
> Cheers,
> Daniel
>>  
>> thank you for any help
>>  
>> George  
>>  
>>
>>
>>   Disclaimer
>>
>> The information in this e-mail and any attachments is confidential. It 
>> is intended solely for the attention and use of the named 
>> addressee(s). If you are not the intended recipient, or person 
>> responsible for delivering this information to the intended recipient, 
>> please notify the sender immediately. Unless you are the intended 
>> recipient or his/her representative you are not authorized to, and 
>> must not, read, copy, distribute, use or retain this message or any 
>> part of it. E-mail transmission cannot be guaranteed to be secure or 
>> error-free as information could be intercepted, corrupted, lost, 
>> destroyed, arrive late or incomplete, or contain viruses.
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Users mailing list
>> Users at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/users
>>   
> 
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users


-- 
Klaus Darilion
nic.at