multiple pulldown or checkboxes

2 posts by 2 authors in: Forums > CMS Builder
Last Post: March 23, 2011 (RSS)

Archived
Reply
Reply

By 4cdg - March 23, 2011

I am setting up a site that has password protected areas so only certain users can see certain files.

I have used the cms cookbook to setup this before, but what I am trying to do is not working. I have a section called files that is a multiple section editor. each record then has a field that populates a list of the accounts. I want to be able to select multiple accounts and give them access to an individual record. everything works if i use a pulldown or radio box for the user selection but i need multiple selections to work. also when i login as admin I can see all the records in my viewer.

the where statement on my viewer is this

'where' => " (user_access = '{$CURRENT_USER['num']}') OR '{$CURRENT_USER['isAdmin']}'",

user_access is the pulldown list

I can send you the code and the urls

Re: [4cdg] multiple pulldown or checkboxes

Archived
Reply
Reply

By Jason - March 23, 2011

Hi,

If you're searching as part of a multi-select list, you need to use the LIKE operator and put tab characters before and after your search option. Try this:

'where' => "user_access LIKE '%\t". intval($CURRENT_USER['num'])."\t%'",

Hope this helps

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/