Yep, is that's what you're after then you need to use like as some
other folks have outlined.
On Thu, 4 Nov 2004 15:39:42 -0600, Kevin Fricke <[EMAIL PROTECTED]> wrote:
> 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
>
>
--
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
