MySqlCommand.ExecuteScalar() returns double while result is long
Posted: Fri 03 Jun 2005 16:00
Hi I am using
MySQLDirect .NET Data Provider 2.50 with
MySQL 4.1 on
Windows 2003 Server (.Net framework 1.1)
when I execute
SELECT SUM(foo) FROM bar WHERE user_id = 1
MySqlCommand.ExecuteScalar() returns 7017639583.0 while the actual result should be 7017639583 as the data type of foo column is int
exeucted the same query in MySQL Query Browser and got the correct result
7017639583
Please help.
MySQLDirect .NET Data Provider 2.50 with
MySQL 4.1 on
Windows 2003 Server (.Net framework 1.1)
when I execute
SELECT SUM(foo) FROM bar WHERE user_id = 1
MySqlCommand.ExecuteScalar() returns 7017639583.0 while the actual result should be 7017639583 as the data type of foo column is int
exeucted the same query in MySQL Query Browser and got the correct result
7017639583
Please help.