I am using MS Indexing Service to seach some files on the filesystem and then display the results in a search webpage based on a users query. Here is the query I am using:
SELECT filename, path, rank, characterization, write
WHERE filename <> 'search.aspx'
AND FREETEXT(Contents, '" + txtSearch.Text + "')
ORDER BY rank DESC
When I put the results of these searches to a grid view, and set the grid view to autogenerate all columns, I get the following columns:
filename, path, rank, write
The characterization column is missing. Not blank, mind you, but just not there. I have checked on "generate abstracts" in the Indexing service, and have rebuilt the catalog a few times already. What am I doing wrong here?
For the record, I noted that when I pass a column name that MSIDX does not support (anything, like "filecharactercountandsize") an error is thrown. So is is clear that is accepts the column name "characterization", but its not returning content (and it's hiding the column)