Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 9th, 2006, 03:38 AM
Registered User
Join Date: Sep 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help with search relevance

Hi all,

Can anyone assist with search relevance?

I am trying to do a SQL search on a table from a ASP page which allows the user to either search by 'all words', 'any words' or 'exact phrase'. The user types in keyword(s) and each are then seperated by the space (with the exception of exact phrase search) and searched against the SQL table.

I am using charindex to search for specific words in small fields such as name. I have also switched on Ful Text Indexing for a larger field called Search (which is an amalgamation of various fields). For this field I use the CONTAINSTABLE and weighted search (ISABOUT)

At the end of the statement, I have 2 sums from charindex called NameScore and MetaScore and then the RANK from the CONTAINSTABLE search. The select statement is then put into a derived table to get me a total of all 3 scores and I order it by this.

OK, so I have the order of the highest scoring records, but I am at a loss how to do relevance. By this I mean 100%, 78% etc. Can anyone suggest any algorithms?

Looking forward to any replies. Thanks!

Similar Threads
Thread Thread Starter Forum Replies Last Post
Articles/links that have TBH relevance jimibt BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 13 December 16th, 2008 04:51 PM
New text search doesn't preselect search string planoie Visual Studio 2005 0 July 23rd, 2007 06:47 AM
File Search / Indexing Search with .net 2.0 maulik77 ASP.NET 1.0 and 1.1 Basics 2 March 15th, 2007 12:45 AM
Search Engine for Full-text Search Kala ASP.NET 1.0 and 1.1 Professional 2 August 29th, 2004 02:16 AM
Search engine that search through local drive! wenzation Classic ASP Basics 0 August 26th, 2003 09:15 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.