Solved

Abstract (characterization) from Microsoft Index Server (msidxs) not displaying in gridview

Posted on 2007-03-29
3
991 Views
Last Modified: 2013-12-09
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)
0
Comment
Question by:Ike23
  • 2
3 Comments
 
LVL 19

Accepted Solution

by:
DreamMaster earned 500 total points
ID: 18821924
Have you tried writing out the values without the use of a gridview, or even without using "AutoGenerateColumns" for that matter (that way you can define what columns you want to show and could check if it actually works)

Regards,
Max.
0
 
LVL 4

Author Comment

by:Ike23
ID: 18821951
Wow! that was it. Thankyou thank you thank you!
0
 
LVL 19

Expert Comment

by:DreamMaster
ID: 18821976
Glad to have been helpful :)

Regards,
Max.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question