If you literally want to run a query on the list (but if it's just a simple list I don't really see what benefit this gets you), you could loop through your list and build a query object manually from your list using QueryNew(), QueryAddRow(), and QueryAddColumn(). It might be more helpful if you let everyone know what you're trying to do overall because there might be a better way to go. (Not saying there is, just saying there might be.)
Matt On Thu, 4 Nov 2004 14:03:14 -0600, Kevin Fricke <[EMAIL PROTECTED]> wrote: > i realize that, but what if i want to run a query on the list? > > for example > > select ID > from Students > where ???? > > I want to pull any student which has an A or B in the list. > > The grades field could have the following data "A,B,D,E" or just "A" > > Make any sense? > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Matt Woodward > Sent: Thursday, November 04, 2004 1:51 PM > To: [EMAIL PROTECTED] > Subject: Re: query of a list > > ListFind will do the trick: > <cfset myList = "1,2,3" /> > <cfset myPos = ListFind(myList, 3) /> > > myPos will be set to the position in the list of the number 3, which > in this case is 3. > > Hope that helps, > Matt > > On Thu, 4 Nov 2004 13:45:10 -0600, Kevin Fricke <[EMAIL PROTECTED]> > wrote: > > 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 > > > > > > -- > 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
