Thanks for this post. I've not had time to get back into this yet, but will run some experiments against the data I've got to see what actually works best. Worst case would be three or four email addresses being searched for in a result list of 4000 or so returned from the database.
> I have created a new blog post where I have taken the code for indexOf() from > java and > modified it to work in this manner for ColdFusion. > > -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351009 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm