value="#form.group#" list="Yes">)
> -----Original Message-----
> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 12 maart 2004 2:24
> 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]
