lukas
|
| Posted: 10/08/2002, 10:22 AM |
|
does anyone knows a way to retrieve ENUM values of a MySQL table for showing them in a listbox?
======
CREATE TABLE `tabUser` (
`userID` int(11) NOT NULL auto_increment,
`nickname` varchar(25) default NULL,
`password` varchar(50) default NULL,
`firstname` varchar(25) default NULL,
`userlevel` varchar(20) default '20',
`name` varchar(25) default NULL,
`yob` year(4) default NULL,
`sex` enum('female','male') default NULL,
`mobile_device` enum('SMS','NOKIA 7650','SonyEricsson T68i') NOT NULL default 'SMS',
=====
thanks
lukas.
|
|
|
 |
Nicole
|
| Posted: 10/09/2002, 7:26 AM |
|
Lukas,
Select mobile_device field for both Text and Buondary columns in ListBox properties.
|
|
|
|
lukas
|
| Posted: 10/10/2002, 12:21 AM |
|
nicole
that's not working with me... i always get a result set with three entries, which is either empty or filled with three times the same value or something inbetween. depending on the ENUM values...
thanks anyway!
lukas.
|
|
|
|
Nicole
|
| Posted: 10/11/2002, 5:10 AM |
|
Lukas,
was Data Type have you selected for listbox? I used "text" type and it working for me.
|
|
|
|
|
