What is the best handling for this situation.

Have a field called "OptionA", for example, that has several options that can have no options checked or several.

The visitor needs to be able to indicate the options in the add and modify routines.

I tried setting up an ENUM database column in the Links table that had the options available set in the Column Values, Form Names and Form Values. Call them A, B, C and D.

In the admin, I see the checkbox options, and when I check one option, it remembers and shows this when I edit a link. But if more than one option is selected, it appears empty.

Any help would be appreciated.

Lance Rasmussen

I believe the multi select problem is caused by the enum field. I use the same checkbox type multi with a CHAR field and it works fine from the admin. I believe enum fields by definition can only be 'one of' the choices.

See this thread for problems associated with the user selecting multiple choices

http://gossamer-threads.com/...earch_string;#221647
Richard White
http://www.AffiliateFirst.com

Hi,

As far as I am aware, the problem is only for multiselect form fields. I'm using checkboxes with ENUM fields and they seem to be working without problems - both in the admin and in add/modify. (Maybe I'm just lucky!)

Laura.
The UK High Street

Are you sure that the names you have in the form names and form values are exactly the same and in the same order? Its easy to make this mistake - I've done it.

Have you tried it with CHAR just in case this is the problem?

Does it make any difference which two of the A,B,C and D you check?