if I use ... Like 'fish%' then i can return 'fish bean bag toy' if I use ...Like 'fish' I would only return an exact match for fish.
Maybe I read it wrong (and obviously forgot about erik's post who mention the like) I thought he was look for a particular number there for the wild cards in case the number is in the middle. of course you could take that field and split it since it's delimited and look for the number in the substring but that seems like a lot of work. On Thu, 4 Nov 2004 13:42:35 -0800, Mukesh Saxena <[EMAIL PROTECTED]> wrote: > Use following syntax > > Select * from tours where tourtype like '%' + #UserVariable# > + '%' > > Where UserVariable = '17' a dynamic value. > > Mukesh > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Behalf Of Kevin Fricke > Sent: Thursday, November 04, 2004 1:40 PM > To: [EMAIL PROTECTED] > Subject: RE: query of a list > > no error. Here is the scenario: > > if i say select from tours where tourtype IN ('17'), it > pulls up tours with > ONLY 17 in it. Not tours where 17 is just contained with in > the > list....76,17,85,12,44,2,1 > > Kevin > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Behalf Of Matt Woodward > Sent: Thursday, November 04, 2004 3:24 PM > To: [EMAIL PROTECTED] > Subject: Re: query of a list > > 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 > > ---------------------------------------------------------- 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
