We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Search using Microsoft Indexing Server does not return titles

Medium Priority
394 Views
Last Modified: 2012-05-07
Hi all,
We are using Microsoft Indexing Server for our website search. The query we are using brings back the results we want with the exception that most of them are missing the title(doctitle). I noticed that the few search results that do show the title are pdfs only, but not all pdfs searched include the title.  What could we be missing?
Also, is there a easier way to exclude file types instead of having to filter out the results through the query using "filename not like '%.cs' and filename not like '%.config'"??

Thanks in advance.
System.Data.OleDb.OleDbConnection odbSearch = new System.Data.OleDb.OleDbConnection("Provider=\"MSIDXS\";Data Source=\"TEST\";");
        System.Data.OleDb.OleDbCommand cmdSearch = new System.Data.OleDb.OleDbCommand();
        cmdSearch.Connection = odbSearch;
 
        string searchText = txtSearch.Text.Replace("'", "''");
        cmdSearch.CommandText = "select doctitle, filename, vpath, rank, characterization from scope() where FREETEXT(Contents, '" + searchText + "') and filename not like '%.master' and filename not like '%.cs' and filename not like '%.config' order by rank desc ";
 
        odbSearch.Open();
 
        try
        {
            OleDbDataReader rdrSearch = cmdSearch.ExecuteReader();
            while (rdrSearch.Read())
            {
                getpagelink(rdrSearch["DOCTITLE"].ToString(), rdrSearch["VPATH"].ToString(), rdrSearch["CHARACTERIZATION"].ToString());
                //getpagelink(rdrSearch[0].ToString(), rdrSearch[2].ToString(), rdrSearch[4].ToString());
            }
 
        }

Open in new window

Comment
Watch Question

Do the documents missing titles, really have titles?
 

Author

Commented:
I am able to update each documents' (such as pdfs, word docs, excel, etc) title property so that they display properly. However, webpages (ASPX, HTML, etc) title  does not show up. Each page has its title property/tag setup in the code, but the search does not pick it up.

Author

Commented:
Can someone please help me with this?? We are planning on launching our site ASAP and this is the last piece we have left to get working....
Any suggestions will be appreciated

Thanks

Author

Commented:
The question was posted almost a month ago and we have recieved very little help (only 1 comment ! ). We need an answer to this, it is important so that our site works properly. There has to be some expert(s) that could give us a lead or an idea on why all our .ASPX webpages won't display their title. If this question is deleted I will be forced to open a new question for my unresolved issue.
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Our .aspx pages do not have a <title> tag since they all reference a master page. What they do have is the title property defined within the <page> tag, but the search does not pick it up.
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
well, according to the above, that is the reason, then...

Author

Commented:
Is there any workaround?? Or another way I could query the <%@ Page Title="page title"%> property?? Or maybe even the files' title property?
If so, that would work for us instead of getting blank search titles for the doctitle...
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
>Is there any workaround??
not that I know (of course, short of writing your own indexing service ...)
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.