MySqlCommand.ExecuteScalar() returns double while result is long

MySqlCommand.ExecuteScalar() returns double while result is long

Postby LS » 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.
LS
 

Postby Serious » Mon 06 Jun 2005 12:31

Please download newest version of MySQLDirect .NET.
Serious
 


Return to dotConnect for MySQL