Re: How to select and set enum by string value

2004-04-03 Thread Roger Baklund
* Eldon Ziegler > I've been unable to select or set an enum field by using the > string values. > Numeric values work correctly. > SHOW CREATE TABLE gives the following: > > CREATE TABLE `Organizations` ( >`OrgID` int(11) NOT NULL auto_increment, >`Organization` varchar(50)

How to select and set enum by string value

2004-04-03 Thread Eldon Ziegler
I've been unable to select or set an enum field by using the string values. Numeric values work correctly. SHOW CREATE TABLE gives the following: CREATE TABLE `Organizations` ( `OrgID` int(11) NOT NULL auto_increment, `Organization` varchar(50) NOT NULL default '', `