I have a legacy app in which I need to enable search.
Recently we've switched to SQL 2008 and I was wondering to do it with it's Full Text Search.
However my question is...is there API available for Cl开发者_C百科assic ASP? Any references?
You can use Full text search features of the SQL server. Create a stored procedure uisng Free text searh indexing features(Use contains & Free text keywords in SQL query). You need create Index and catelog for your database.
Call the stored procedure from classic ASP.
I think full text search is a completly service side feature and that you only send normal SQL queries in which case normal ADODB should be sufficent to use it.
But I have never tried fulltext service my self so I am not a 100 % sure.
精彩评论