Hello All,I am trying write webpart related with search functionality in sharepoint and FullTextSqlQuery returns unexprected result. I couldn't understand why. In following code I am expecting results for default sharepoint ( sharepoint:80 ) website but it returns cental administration site search results.DataTable resultDataTable = new DataTable();FullTextSqlQuery FTQ = new FullTextSqlQuery(SPContext.Current.Site);FTQ.ResultTypes = ResultType.RelevantResults;FTQ.QueryText = "SELECT FileExtension, ContentClass, IsDocument, rank, title, path, author from scope() ";
ResultTableCollection resultTableCollection = FTQ.Execute();ResultTable resultTable = resultTableCollection[ResultType.RelevantResults];resultDataTable.Load(resultTable);In resultDataTable (path column) all rows related with Centeral Administration site. So, do you have any idea why?PS: I have tried following way to make sure it is runing on default web site;insted of "new FullTextSqlQuery(SPContext.Current.Site);", I put "new FullTextSqlQuery(new SPSite(http://sharepoint:80));" but result is same.
View Complete Post