(#ListQualify(form.group,"'")#). No need to loop at all.
> -----Original Message-----
> From: Craig Earls [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 12 maart 2004 3:41
> To: CF-Talk
> Subject: RE: Multiple Selections to populate a SQL or operator.
>
> Use the list functions to break apart the group variable and
> loop through 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]
