Solved

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

Posted on 2007-03-29
3
997 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

734 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