I have a page that grabs a list of numbers, either from a series of checkboxes, or a multiple select box, and it passes the Value of the item…
<select name=“Seminars” multiple=“multiple” size=“10”>
when you submit the page, and you select multiple items from the box, you’re going to get a list returned back in the form.seminars… ie. (1,2,3), here you could utilize the list attribute in cfqueryparam to work for you in trying to grab some rows from the database only where what was selected is relevant…
<cfquery name=“qGetSeminarsUsers” datasource=“#datadsn#”>
su.userid, su.seminarid as id, su.fname, su.lname, su.email
FROM seminarusers su
WHERE su.seminarid IN
as a begginer you may try to loop through the list in your query to grab all of the id’s and use a lot of “AND” “OR” sql statments in you’re WHERE clause. BUT using the “IN” clause in conjunction the the list=”yes” feature of cfqueryparam, it makes this query a breeze.