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
