it's good. if you've got someone searching for something like fish monkey paste tree
to do this in sql you're going to end up with a nasty query using likes (especially if you're OR'ing each word!), which is slow. also might have to search against multiple fields, e.g WHERE Description LIKE '% #form.search#%' OR keywords LIKE '%#form.search#%' etc. verity can do it all pretty quickly. also it does the whole stemming thing, where searching for 'fat' will also get you fatty, fattest, fathead, fatwa, father, etc. and much more besides Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> dexpo.com> cc: Subject: [ cf-dev ] Verity 24/07/2003 13:06 Please respond to dev What are peoples opinion on using Verity instead of standard SQL searches? Pro's / Con's etc... ColdFusion 5.0 Ta N -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
