each list item.
-----Original Message-----
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 8:24 PM
To: CF-Talk
Subject: Re: Multiple Selections to populate a SQL or operator.
Thanks Nick,
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]
