No problem, yep FTS is great but it can be pretty CPU intensive so make sure you test these results under simulated load to ensure that your server does not get beaten down with requests.
-----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 24 January 2005 10:03 To: CF-Talk Subject: Re: CFQUERY -->-> Stored Procedure >The Proc is looking for a like within the string '[EMAIL PROTECTED]' - you >will need >to do the following: Excellent, that works perfectly, thanks! I just figured out full text searching last night, and think I'm going to create a catalog for this db and give it a shot. Thanks again for your solution! Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191526 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

