Link to home
Start Free TrialLog in
Avatar of Ike23
Ike23Flag for United States of America

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)
ASKER CERTIFIED SOLUTION
Avatar of DreamMaster
DreamMaster

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ike23

ASKER

Wow! that was it. Thankyou thank you thank you!
Avatar of DreamMaster
DreamMaster

Glad to have been helpful :)

Regards,
Max.