Ike23
asked on
Abstract (characterization) from Microsoft Index Server (msidxs) not displaying in gridview
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
FROM scope()
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)
SELECT filename, path, rank, characterization, write
FROM scope()
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to have been helpful :)
Regards,
Max.
Regards,
Max.
ASKER