Im probably way off what you mean select list from table
<cfset success = Listfind(query.list, #ID#)> <cfif success> SUCCESS <cfelse> DENIED </cfif> ----- Original Message ----- From: "Tony Gruen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 6:42 PM Subject: Query Issue > Howdy List! > > Can someone please 'gimmie a thread' on this? (ie: Brain thread, as in cpu > thread) > > I have an existing database with a field named 'AccessList'. This field is a > comma delimited list of IDs (numeric only). These IDs are for users who are > to be granted access to a function. For example one entry would be > 4,15,26,44,101,9. > > I am trying to devise a query that will check the field for a single userID. > Say 4 for example... note that 44 also exists in the list. > > My fumbling attempts to devise a way using LIKE and IN are not working. > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
