I try to put decimal data to do a prepaid system! In fact, I need to do operations like 25.24/0.15. I cant do $var(a)=25.4/0.15;

I could see that if I do for example $var(a)=166/100; $var(a)=1 ! ! ! How can I do to have $var(a)=1.66 ?

Thank you

Cordialement, BERGANZ François  Pensez à l'Environnement, n'imprimez ce mail que si nécessaire.

-----Message d'origine----- De : users-bounces@lists.kamailio.org [mailto:users-bounces@lists.kamailio.org] De la part de Saúl Ibarra Envoyé : lundi 1 juin 2009 17:05 Cc : users@lists.kamailio.org Objet : Re: [Kamailio-Users] problems with artihmetics operations & MYSQL

What field type are you trying to put the data in?

On Mon, Jun 1, 2009 at 4:51 PM, BERGANZ François francois@acropolistelecom.net wrote:

Hello,

I need to select from a database (for example 25.6546)

And I need to do 25.6546/60.

I think that I have a problem with my MySQL database. I tried to insert the 25.6546 in a decimal(5,5) but I cant insert more than 0.99999 !

Anyone know how to do ?

Thank you

Cordialement,

BERGANZ François

P Pensez à l'Environnement, n'imprimez ce mail que si nécessaire.

---

Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users

What does it mean? Have you an example ?

Cordialement, BERGANZ François  Pensez à l'Environnement, n'imprimez ce mail que si nécessaire.

-----Message d'origine----- De : Juha Heinanen [mailto:jh@tutpro.com] Envoyé : lundi 1 juin 2009 17:22 À : BERGANZ François Cc : users@lists.kamailio.org Objet : Re: [Kamailio-Users] problems with artihmetics operations & MYSQL

BERGANZ François writes:

In fact, I need to do operations like 25.24/0.15.

change your unit to micros and they will be ints.

-- juha