something wrong.
Regards,
Julien
-Message d'origine-
De : Mark Matthews [mailto:[EMAIL PROTECTED]
Envoyé : lundi 21 février 2005 16:24
À : LAFONTAINE Julien - LYO
Cc : mysql@lists.mysql.com
Objet : Re: Problem with SUM and DECIMAL field
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
LAFONTAINE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
LAFONTAINE Julien - LYO wrote:
Hi Mark,
Thank you for your help.
I have the same problem when I execute the query with the MySQL client on my
AIX server :
mysql select sum(AMFTPF) from DWH_AMF;
+-+
| sum(AMFTPF) |
Hell.
I think you should read comments at:
http://bugs.mysql.com/bug.php?id=1388
They are related to the ODBC connector, but may be it will
help you to solve problems with Connector/J.
LAFONTAINE Julien - LYO [EMAIL PROTECTED] wrote:
Hi everyone,
I've recentely upgarded
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
LAFONTAINE Julien - LYO wrote:
Hi everyone,
I've recentely upgarded my servers from MySQL 3.23.49 to MySQL 4.1.9.
Now I have a problem when using the SUM operator on DECIMAL field.
The value returned by the SUM operator when used with
Because neither 0.7 nor 0.1 have an exact binary floating point
reprsentation.
Use Decimal type instead.
LeTortorec, Jean-Louis wrote:
Hello every one,
I have a simple table, with a float field called quantity.
In this table, there are 2 records: 1 with quantity=0.7, and 1 with
quantity=0.1.
]
Sent: Thursday, April 03, 2003 1:40 PM
To: '[EMAIL PROTECTED]'
Subject: Problem with sum()
Hello every one,
I have a simple table, with a float field called quantity.
In this table, there are 2 records: 1 with quantity=0.7, and 1 with
quantity=0.1.
When I do a select sum(quantity) from
Thanks, I'll do that.
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 4:52 PM
To: LeTortorec, Jean-Louis
Cc: '[EMAIL PROTECTED]'
Subject: Re: Problem with sum()
Because neither 0.7 nor 0.1 have an exact binary floating point
Hi,
I have got 2 tables one of the is customers the other is bill. In the
customers table i store my customers informations. In the bill table i store
my billings. if i take a bill bill.direction=0, if i give a bill
bill.direction=1. And now i must take a report Like This..
Customer Code
By looking at your query and table description, I guess you can try
something like:
SELECT cus.`Code` AS `Customer Code`,
cus.`Name` AS `Customer`,SUM((1-bil.direction)*bil.Total) AS Loan,
SUM(bil.direction*bil.Total) AS Credit
FROM customer AS cus,
bill AS bil
WHERE bil.`Customer` = cus.`ID`