Re: enum errors - what is the correct syntax?

2001-10-23 Thread Carl Troein
McGrotty, Charles writes: > I have been bashing my head for a couple of hours now trying to > create an enum field which will hold a true or false (1 or 0) > value, but I always get an error when I try to create the enum > field. An ENUM can only hold strings, so you're probably missing the quo

enum errors - what is the correct syntax?

2001-10-23 Thread McGrotty, Charles
Hi, I have been bashing my head for a couple of hours now trying to create an enum field which will hold a true or false (1 or 0) value, but I always get an error when I try to create the enum field. What is the SQL syntax to create such a field in phpMyAdmin? I tried to use the building tools