I'm looking for a way to perform full-text keyword searching on particular columns in a SQL database (Sybase, SQL Server), with wildcards, boolean ops and natural language if possible, via ASP scripts on IIS.
Microsoft Index Server only searches files in directories, not queries on a database. Their suggestion is to output each database row to an individual file, then index it. Kludge!!
Cold Fusion lets you query a database via the Verity search engine that comes packaged with it. Very nice, but we gave up CF because it's slow, buggy and lacks a decent programming language.