MSSQL2008 Full Text Search - how to create a search page in ASP, not ASP.net

Jamie
Jamie used Ask the Experts™
on
Hi All,
I've created a full text catalogue (called FT_Testit) on one table called TestTable on my MSSQL2008 database, and I'm now trying to find some asp (not asp.net) code that will allow me to perform searches against it - but I'm not having much luck!

Ideally it would be a form that passed parameters to the asp search script - at the moment, I don;t even know how to reference the full text catalogue in asp!

As always, any help you can offer will be greatly appreciated.

Regards
JamWales
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
Commented:
In order to make use of the Full text index, you need to modify ur query to use CONTAINS /CONTAINSTABLE statements
here is an example
USE AdventureWorks;
GO
DECLARE @SearchWord varchar(30)
SET @SearchWord ='performance'
SELECT Description
FROM Production.ProductDescription
WHERE CONTAINS(Description, @SearchWord);--- the normal where condition for this statement will be WHERE Description LIKE '%'+@SearchWord+'%'

Author

Commented:
Hi aneeshattinga,
Thanks for your reply - Is it possible to rang the results returned from the select statement?
Regards
JamWales

Author

Commented:
All sorted - thanks for your help.
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

AneeshDatabase Consultant
Top Expert 2009

Commented:
I did n't understand your question, can you elaborate
Top Expert 2012

Commented:
I suspect the author wants to use the RANK functionality with the CONTAINSTABLE() clause.

Author

Commented:
Hi aneeshattingal,
Yes, sorry my mistake  - I did mean RANK not RANG! Given you initial guidance, I sorted out the script and also got ranking working - thanks again for your help.
Regards
JamWales
Top Expert 2012

Commented:
You are welcome.  :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial