Using list value in where clause

Hi,

Could you provide some more information on what you're trying to accomplish? Are you trying to select records from different sections that have selected a video?

Please let me know as much information as you can and we'll suggest some options.

Thanks.

In the cms I have a multi record set. One of the fields (section) is a list field with checkboxes, so checkbox 1 has a value and checkbox 2 has a value. I want to pull records in the viewer dependent upon what the value of section is.

I want to list all entries that match

where => 'section="the value of checkbox1"'

hope this helps explain what I am doing.

Ok,
I have split out the values rather than a multi pull down check boxes (where i wanted the option of appearing in 1 or both sections) I have done them as individual sections. So each section has its own checkbox field. There is a problem with the cms however, the cms allows you to put a value in the checkbox 'yes' and checkbox 'no' fields, however when initiating a where clause you can not put where => 'fieldname="yes"', you have to put where =>'fieldname="1"', or 0 depending on what you want. It should be the value, if you are allowed to put a value in there?

Hey Zaba,

Yes. the checkbox is stored in the database as 1 or 0 instead of the checkbox labels. A bonus of this method is you can change the label without needing to update any database values. That also means you wont have to change your code if the labels change.

Hope that helps,
Robin