Wouldn't you just do...
Select *
>From Students
Where Grade in ('A','B','D')
That would give you all students with a grade of A, B, or D in the Grade
column. You can put as many inside the () you want... It also can be a
select statement inside of the () instead of a comma list (the results from
the select are what will be checked against). The select statement allows
you to have your grades in another table. Am I over simplifying this?
Dax
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Kevin Fricke
Sent: Thursday, November 04, 2004 2:13 PM
To: [EMAIL PROTECTED]
Subject: RE: query of a list
i thought about that...i was hoping there was a better way. There may be a
time when the field has numbers in it and I don't want to pull a record with
"11" in the field if I am only looking for "1".
should i just avoid using a list in the field?
Kevin
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Knipp, Eric
Sent: Thursday, November 04, 2004 2:06 PM
To: '[EMAIL PROTECTED]'
Subject: RE: query of a list
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
----------------------------------------------------------
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
