[Kamailio-Users] problems with artihmetics operations & MYSQL

2009-06-01 Thread BERGANZ François
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.9 ! Anyone know how to do ? Thank you Cordialem

Re: [Kamailio-Users] problems with artihmetics operations & MYSQL

2009-06-01 Thread Saúl Ibarra
What field type are you trying to put the data in? On Mon, Jun 1, 2009 at 4:51 PM, BERGANZ François 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

Re: [Kamailio-Users] problems with artihmetics operations & MYSQL

2009-06-01 Thread BERGANZ François
l'Environnement, n'imprimez ce mail que si nécessaire. -Message d'origine- De : users-boun...@lists.kamailio.org [mailto:users-boun...@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

Re: [Kamailio-Users] problems with artihmetics operations & MYSQL

2009-06-01 Thread Juha Heinanen
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 ___ Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/list

Re: [Kamailio-Users] problems with artihmetics operations & MYSQL

2009-06-01 Thread BERGANZ François
ts.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 ___ Kamailio (Op

Re: [Kamailio-Users] problems with artihmetics operations & MYSQL

2009-06-01 Thread Juha Heinanen
BERGANZ François writes: > What does it mean? > Have you an example ? for example, if you are dealing with money, change 15.45 => 1545 or 154500. -- juha ___ Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/

Re: [Kamailio-Users] problems with artihmetics operations & MYSQL

2009-06-02 Thread Alex Hermann
On Monday 01 June 2009 16:51:43 BERGANZ François wrote: > 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.9 ! This is not a kamailio issue. You specified a field of 5 digits, of course MySQL will not let you