?
Solved

Get Characterization data from Index server?

Posted on 2004-11-11
8
Medium Priority
?
650 Views
Last Modified: 2012-06-22
Iv'e got the search page working which returns:

SIZE, FILENAME, VPATH, WRITE, RANK

the problem is my search string looks like this:

SELECT DocTitle, Size, Filename, Vpath, Write, Characterization, Rank
FROM SCOPE('DEEP TRAVERSAL OF ""/""')
WHERE FREETEXT('" & TextBox1.Text & "')
ORDER BY rank"

you can see that the returned fields do not include DocTitle and Characterization.  I have clicked "Generate Abstracts" and have restarted server and service.  

When I look in the catalogs properties:
Characterization  =  VT_LPWSTR   4   Secondary
DocTitle  =  VT_LPWSTR   4   Secondary

Does anyone have any suggestions?
0
Comment
Question by:westbergk
  • 3
  • 3
7 Comments
 
LVL 33

Expert Comment

by:raterus
ID: 12560099
You have the wrong group, this question doesn't have anything to do with asp.net!

0
 
LVL 1

Author Comment

by:westbergk
ID: 12560228
The search page is written in asp.net...

When I use my asp version it returns this info without any issues.  So I assume it does have something to do with a portion of either asp or ado.net...  I guess thats why I'm here.

0
 
LVL 33

Expert Comment

by:raterus
ID: 12560311
If it runs the same in ASP, it may be a security issue on your filesystem.  (At least it looks like you are querying a filesystem..)

try adding this to your web.config, and see if it makes a difference
<identity impersonate="true" userName="MYDOMAIN\SomeAdminAccount" password="password" />

This would not be a solution, just a way for you to narrow down the problem.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 1

Author Comment

by:westbergk
ID: 12560399
same outcome...

I just tried using all phrases available and it returned the following fields:

SIZE,FILENAME,VPATH,WRITE,RANK,SHORTFILENAME,PATH,FILEINDEX,DIRECTORY,CREATE,ATTRIB,ACCESS

from this query:

SELECT
Characterization, DocTitle, Size, Filename, Vpath, Write, Rank, ShortFileName, Path, FileIndex, DocWordCount, DocTitle, DocTemplate, DocSubject, DocParaCount, DocPageCount, DocManager, DocLineCount, DocLastSavedTm, DocAppName, Directory, Create, Contents, ClassId, Attrib, Access, DocLastPrinted, DocLastAuthor, DocKeywords, DocCreatedTm, DocCompany, DocComments, DocCharCount, DocAuthor

FROM SCOPE()
WHERE FREETEXT('" & TextBox1.Text & "')
ORDER BY rank desc"

the result is filling a datagrid with auto populate set to true.  So the order that the grid is rendering is the order it's receiving.  Which means Characterization and DocTitle are not even available... along with all the others not showing up.

0
 
LVL 33

Expert Comment

by:raterus
ID: 12560482
I don't have any experience with these queries, and I really doubt many people who browse this group do either.  Heck I've even used full-text search, and you got me baffled.  I'd try posting it here microsoft.public.sqlserver.fulltext, The guys there are really good about getting you an answer.

http://communities.microsoft.com/newsgroups/default.asp
0
 
LVL 1

Author Comment

by:westbergk
ID: 12560691
I found the following link which answers the missing field issues...

http://www.webservertalk.com/archive125-2004-3-154159.html

It appears the datagrid has a problem with the way the index server returns it's data.  I just looped thru a reader and everything was there... Good old asp table rendering comes to the rescue.

I'll keep this open for a few days to see if anyone has a better solution than stepping thru a reader.

Keith
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12799364
PAQed with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

749 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