 | | | Min, Max value from MYSQL 4.1.8 and ODBC 3.51.10 | Min, Max value from MYSQL 4.1.8 and ODBC 3.51.10 2004-12-21 - By Uher, Lubomir
Back
Hello all,
I would like to ask you for help with this query. I use VB6 and MyODBC
3.51.10 connection. Problem is that, return value from query :
select min(date1) as MinDate, max(date2) as MaxDate from tabledata
is null for MinDate, but OK value for MaxDate. Could you describe to me, why
? Could you give me some advice for solution. ( Table definition is below )
Table definition :
CREATE TABLE `tabledata` (
`id` int(11) NOT NULL auto_increment,
`date1` datetime NOT NULL default '0000-00-00 00:00:00',
`date2` datetime NOT NULL default '0000-00-00 00:00:00',
`locplace` char(3) NOT NULL default '-',
`host` varchar(15) default '000.000.000.000',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Many thanks.
Lubomir
*******************************************************************************
***************
The information contained in this message or any of its attachments may be
confidential and is intended for the exclusive use of the addressee(s). Any
disclosure, reproduction, distribution or other dissemination or use of this
communication is strictly prohibited without the express permission of the
sender. The views expressed in this email are those of the individual and not
necessarily those of Sony or Sony affiliated companies. Sony email is for
business use only.
This email and any response may be monitored by Sony United Kingdom Limited.
(05)
*******************************************************************************
***************
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|