CF8 and MS SQL 2000
I would like to implement Google-esque searching on our Intranet against our database. To do this I enabled Full-Text on the table I want to search (customers) and use a query like this: SELECT * FROM Customer where CONTAINS (*, '" & search & "') This works somewhat but one problem I am having is that: John Doe will not locate a record where firstname=John and lastname=Doe. It does find [EMAIL PROTECTED] however. Both behaviors I find odd. Does anyone know either how to correct the inability to find that record or a better way of doing this all together? BTW, we will be upgrading to MS SQL 2008 in a few months, maybe that has some built in capability that will make this easy? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
