Made changes, now the problem has reversed:
mysql> select count(*) from Associate where Active=FALSE;
+----------+
| count(*) |
+----------+
| 2611 |
+----------+
1 row in set (0.01 sec)
mysql> select count(*) from Associate where Active=TRUE;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.01 sec)
mysql> select count(*) from Associate where Active='1';
+----------+
| count(*) |
+----------+
| 1336 |
+----------+
1 row in set (0.02 sec)
mysql> desc Associate;
+------------------+------------------+------+-----+------------+-----------
-----+
| Field | Type | Null | Key | Default | Extra |
+------------------+------------------+------+-----+------------+-----------
-----+
| ID | int(11) | | PRI | NULL |
auto_increment |
| LocationID | int(11) | YES | | NULL | |
| NTLogon | varchar(8) | YES | | NULL | |
| DomainID | int(11) | YES | | NULL | |
| LastName | varchar(30) | | | | |
| FirstName | varchar(30) | | | | |
| Shift | int(11) | | | 1 | |
| QADE | enum('null','1') | YES | | NULL | |
| DataEntry | enum('null','1') | YES | | NULL | |
| QAMR | enum('null','1') | YES | | NULL | |
| MailRoom | enum('null','1') | YES | | NULL | |
| QAT | enum('null','1') | YES | | NULL | |
| Taping | enum('null','1') | YES | | NULL | |
| QAF | enum('null','1') | YES | | NULL | |
| Filming | enum('null','1') | YES | | NULL | |
| CustomerContact | enum('null','1') | YES | | NULL | |
| Trainee | enum('null','1') | YES | | null | |
| Active | enum('null','1') | YES | | NULL | |
| Creator | varchar(8) | | | | |
| NewAssociateDate | date | | | 0000-00-00 | |
+------------------+------------------+------+-----+------------+-----------
-----+
-----Original Message-----
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 10, 2004 9:35 AM
To: Scott Hamm; 'Mysql ' (E-mail)
Subject: RE: enum TRUE/FALSE
[snip]
I'm trying to figure out how to make Active's null as FALSE and '1' as
TRUE,
in enum point of view....
| Active | enum('','1') | YES | | NULL |
|
[/snip]
I have not tested this but have you tried enum('NULL', '1') ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
