Site search engine

I am building a Q&A type website for a niche market and need to add a search ability to it.

I have an old vbscript code for taking the inputs from the text box and splitting it into Or statements and adding And for the +, not for -, phrases for "" etc but it probably isnt great anymore.Does someone have a link to a good example of how to do this in .Net and then getting back weighted results based on the frequency of each keyword/ phrase appearing?

Google hasnt found anything useful.

Many thanks

if your site is using a database then you can use a dynamically created SELECT statement? With some good SQL coding, you could have a count on the number of occurences on each word.

Good luck

Hi,

you can add google search

http://www.communitymx.com/content/article.cfm?page=2&cid=E8E8CE970C6AB073http://aspnet.4guysfromrolla.com/articles/030503-1.aspx

Look at

http://www.codeproject.com/useritems/Indexing_Service_HOW-TO.asp

The dynamically created select statement is what I had assumed it would look like however cannot think how to do the word count element across multiple columns - whilst I am sure I could work out how to build the SQL statement I was hoping a more up to date version of my VBScript one was available for a low cost purchase.

Many thanks everyone else fo the suggestions, the site is to be hosted on shared account and therefore I am limited in what I can do in terms of indexing service, full text SQL searches etc.

Any suggestions anyone as I am really stuck on this one