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
