You need to create a list to table function on your database server. Using
LIKE command will require an addition OR statement for every grade letter
searched. This is extremely slow, yet works. What DB server are you running?
I have a function to convert for MSSQL.
With such a function then you could write:
SELECT *
FROM students
WHERE grade IN (select ID from master.dbo.ListToTable('#myList#'))
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Kevin Fricke
Sent: Thursday, November 04, 2004 2:03 PM
To: [EMAIL PROTECTED]
Subject: RE: query of a list
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
----------------------------------------------------------
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
