Re: GETTING ENUM FIELD VALUES

Hi Mystery person: > For example, I have a table with a column called approved, it has an enum of > approved, wating approved, and not approved. Is there a way I can > dynamically get there enum values? Just use a normal query string: "select approved from table where .... etc ..." That'll return the text selected in the enum field. If you're looking to get the numeric index value of that text, I don't know of a way, perhaps someone else does. If you're looking to use the text value returned from the query to automatically select the appropriate value in the a list or radio box, then you'll need to rephrase your question to ask such. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y More than just answers. Solutions. (SM) http://www.analysisandsolutions.com/ 4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409