Hi,
I have a strange problem happening. I have created an application on a PC
with Mysql-3.23.22-beta and I have different results than on a standard
Mysql-3.23.35.
The main problem seems to be at the following:
Say have 6 rows with a column name "actif", out of these 6 rows 3 have a
NULL value in the actif column and three have the value "No"
is I do
select count(*) from tablename where actif != "Yes" ; or
select count(*) from tablename where actif <> "Yes" ;
I get the following results:
- development machine: I get results = 6
- production machine: I get results = 3
Note all rows are different than "Yes", only 3 of them are actually NULL.
OK so that is a fact, but I would like to know if it is just a setting I can
change in the database or if I have to modify the whole program to make sure
these cases don't happen.
Gilles
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
