Ken, The listfind is not what I need.
The IN does not work (might be because we are using mySql). Any other ideas? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ken Ferguson Sent: Thursday, November 04, 2004 1:52 PM To: [EMAIL PROTECTED] Subject: RE: query of a list Do you mean in SQL, like: Select * from users where userid in(#myUserIDList#) Or using a cf function like: <cfif listfind(#myuseridlist#, #useridinquestion#)>do something</cfif> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Fricke Sent: Thursday, November 04, 2004 1:45 PM To: CFLIST Subject: query of a list 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 ---------------------------------------------------------- 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
