You need to lose the % signs... Dax
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Ivanoff Sent: Thursday, November 04, 2004 3:31 PM To: [EMAIL PROTECTED] Subject: Re: query of a list Select * from users where userid LIKE (%#myUserIDList#%) On Thu, 4 Nov 2004 15:24:19 -0600, Matt Woodward <[EMAIL PROTECTED]> wrote: > If that IN scenario is what you want, it will work fine in MySQL. The > syntax probably just isn't correct. What error do you get? > > > > > On Thu, 4 Nov 2004 15:19:53 -0600, Kevin Fricke <[EMAIL PROTECTED]> wrote: > > Ken, > > > > The listfind is not what I need. > > > > The IN does not work (might be because we are using mySql). > > > > Any other ideas? > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Behalf Of Ken Ferguson > > Sent: Thursday, November 04, 2004 1:52 PM > > To: [EMAIL PROTECTED] > > Subject: RE: query of a list > > > > Do you mean in SQL, like: > > Select * from users where userid in(#myUserIDList#) > > > > Or using a cf function like: > > <cfif listfind(#myuseridlist#, #useridinquestion#)>do > > something</cfif> > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Kevin Fricke > > Sent: Thursday, November 04, 2004 1:45 PM > > To: CFLIST > > Subject: query of a list > > > > I have a comma delimited list of numbers in a field. What is the > > language for the query to see if a particular number is in that > > list?? > > > > Thanks! > > > > Kevin Fricke > > > > ---------------------------------------------------------- > > To post, send email to [EMAIL PROTECTED] To unsubscribe: > > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > > To subscribe: > > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > ---------------------------------------------------------- > > To post, send email to [EMAIL PROTECTED] To unsubscribe: > > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > > To subscribe: > > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > ---------------------------------------------------------- > > To post, send email to [EMAIL PROTECTED] To unsubscribe: > > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > > To subscribe: > > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > > > -- > > > Matt Woodward > [EMAIL PROTECTED] > http://www.mattwoodward.com > ---------------------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
