Why do it in the query? Grab your list and loop over it until you find a true.
You should probably make another table and related that field out instead of making a comma delimited list in the db... but maybe you don't have control over the db. At 03:42 PM 5/20/2002 -0700, you wrote: >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. > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
