I must be missing something, or don't understand.
My multi select box on page one looks like this"
<select name="group" multiple>
<option value="" selected> Please Select </option>
<cfoutput query="getgroup">
<option value="#mailgroupname#">#mailgroupname#</option>
</CFOUTPUT>
</select>
So the form variable "group" gets passed as a list seperated by commas.
If a user selcts two items, I get "itemone, itemtwo" and the whole thing is called form.group. So, with this setup I've just got the var form.group to work with in my query and it could be one or more items.
I tried: WHERE mail_group in ( '#form.group#')
Which is essentially:
WHERE mail_group in ( '#firstselection,seconmselection#')
and that gave zero results.
Please bear with me, if I'm not explaining myself properly.
-Jeff
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
