You probably will need to use a LIKE comparison in your SQL statement, for
example
SELECT
ID
FROM
Students
WHERE
grade like '%A%'
Hope that helps.
Eric
-----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
-----------------------------------------
CONFIDENTIALITY NOTICE: The information contained in this e-mail and
attached document(s) may contain confidential information that is intended
only for the addressee(s). If you are not the intended recipient, you are
hereby advised that any disclosure, copying, distribution or the taking of
any action in reliance upon the information is prohibited. If you have
received this e-mail in error, please immediately notify the sender and
delete it from your system.
----------------------------------------------------------
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
