Thanks everyone. This helps. We have inherited an access DB that was originally in FileMaker Pro3 and migrated into access 97 by some goombaa. We proposed rebuilding the structure but no sale. It is on an intranet and does not carry any budget dollars for the client.
Tony -----Original Message----- From: Ewok [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 4:07 PM To: CF-Talk Subject: Re: Query Issue 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. > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
