.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

FullTextSqlQuery unexpected result ( Sharepoint 2010 Foundation )

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :SharePoint
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

More Related Resource Links

SharePoint 2010 Foundation: An unexpected error has occurred. Correlation ID error



I am facing an error while loading the Project Server (PWA) site. My server has Windows Server 2008 and SharePoint Server 2010. The SharePoint site working properly. Also the Project Server site was also working properly but after provisioning another site on same farm, I am getting the error as:

An unexpected error has occurred.

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: 353d7757-efa1-4fa4-be03-a027de0fc562

Date and Time: 7/20/2010 4:46:04 AM

Can anyone let me know, what exactly this error is about and how to resolve this.

Thanks in advance!


How to upgrade from Windows SharePoint Services 2.0 to SharePoint Foundation 2010 after mistanely de


I need a detailed instruction on how to upgrade From Upgrading from Windows SharePoint Services 2.0  (SBS 2003 ) to SharePoint Foundation 2010.

Background of the case:

I have all my databases (STS-database and STS_Config) saved but, I forgot to save my Virtual Site )Companyweb site) and I mistakenly re-installed IIS on the SBS 2003, hence  I lost the companyweb site. Is this an issue to migrate to Sharepoint foundation 2010. The Sharepoint foundation 2010 is running on a Microsoft HyperV Server 2008 R2
Also, I have created a Virtual 2003 SRV ENT with Sharepoint Services 3.0 running on it. I also have attached my Databases STS_Database and STS_Config)... how do I get it working like a regular website. I have modified the CNAME record to reflect the new server... http://companyweb - it take me to the new site but it loads a blank page. I did create a new CompanyWeb Virtual site on the VHD 2003 server.
Your help is greatly appreciated.

Thanks for your prompt response. Nelson

Chapter 2: SharePoint Foundation Development (Inside SharePoint 2010)

Learn what's new with the SharePoint developer platform from experts on Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010.

Redeploying Customizations and Solutions in SharePoint Foundation 2010 and SharePoint Server 2010

Learn how to redeploy customizations and custom solutions that you created for Windows SharePoint Services 3.0 and SharePoint Server 2007 in SharePoint Server 2010 and SharePoint Foundation 2010.

Using the SharePoint Foundation 2010 Managed Client Object Model with the Open XML SDK 2.0

Write client-side applications that work with Open XML documents that are stored in document libraries by using these two technologies together.

Using the SharePoint Foundation 2010 Managed Client Object Model

Write applications that are based on the .NET Framework and access SharePoint content from clients without installing code on the server that runs SharePoint Foundation 2010.

Microsoft SharePoint Foundation 2010 Beta - Now Available!

This download contains an installable version of SharePoint Foundation 2010 Beta that can be used to assess and test the new functionality in this release. SharePoint Foundation 2010 is the new version of Windows SharePoint Services.

Overview of the Fluid Application Model in SharePoint Foundation 2010

Discover how the Fluid Application Model, new in SharePoint Foundation 2010, gives you the power to add non-SharePoint applications to your Web Parts.

What's New for Developers in SharePoint Foundation 2010

Find a brief description of the important new features in SharePoint Foundation as well as areas where existing features have been improved and enhanced. Each topic includes links to areas in the SDK where the subject is discussed in more depth.

Use Dashboard designer in Sharepoint Foundation 2010

Hi, I want to Install Dashboard Designer in Sharepoint Foundation 2010(WSS 4). I can only find articles on insatllation in Sharepoint Server 2010..like this one.. http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx?wa=wsignin1.0 Can you please let me know how I can use Performance Point in Sharepoint Foundation?   Thanks  

SQL 2008 Standard Licence for Sharepoint 2010 foundation

Hello! We want setup sharepoint 2010 foundation with an SQL 2008 Standard. The expected amount of data are about 40 GB or more. This the reason why we can't use SQL Express 2008 R2. What Licencemodel is necessary ? - Do we need an Processorlicence, is concurrent ok or need only the Sharpoint Server a Licence for access the database. thank's in advance Christian  

get current selected langauage in sharepoint foundation 2010

Hi every one,                 My need to get current selected language in SharePoint Foundation 2010 site.  I use web.SupportedUICultures but it is return all language,  But my need is current selected language. How I get this.        

set Alternate language(s) in sharepoint foundation 2010 give error

Hi every one,               i have install Language Packs for SharePoint Foundation 2010  from this link http://www.microsoft.com/downloads/details.aspx?FamilyID=0956787E-210D-4D78-9E4E-A9CDEF0E8495&amp;displaylang=es&displaylang=en this exe, SPLP\14.0.4536.1000_SharePointLanguagePack_none_ship_x64_de-de_exe\SharePointLanguagePack.exe  when i set alternate laguage, that this give error. Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed. Details: To enable the details of this specific error message to be viewable on the local server machine, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "RemoteOnly". To enable the details to be viewable on remote machines, please set "mode" to "Off". <!-- Web.Config Configuration File --> <configuration> <system.web> <customErrors mode="RemoteOnly"/> </system.web> </configuration> Notes: The current error page you are seeing can be replace

Sharepoint Foundation 2010 problems with Office 2007 ActiveX controls

I have a SPF server that I recently upgraded from WSS 3 using the database attach method. The new server configuration is SQL 2008 R2 with SPF 2010 on Windows 2008 64bit SP2. Mostly things are working fairly well, though there have been a few fires to put out. The latest inflamation seems to be centered around ActiveX controls for Office 2007. I'm getting the following message whenever I try to create a new document using the New button: " 'New Document' requires a Microsoft SharePoint Foundation-compatible application and web browser. To add a document to this document library, click the 'Upload Document' button." On the client side, the browser is IE8 on Windows 7 (Windows is 64bit, though the browser is in 32 bit mode.) using Office 2007. I've also had the same problem with systems running XP. In terms of troubleshooting, other activeX related features seem to be working fine. I can open datasheet views, if I click on a document, it will open in the appropriate client. However, I have some libraries where the Word document template opens the document information panel and those will give thhe following message on open: "One or more ActiveX controls could not be displayed because either: 1)Your current security settings prohibit running ActiveX controls on thi page , or 2) You have blocked a publisher of one of the contols. As a result the page mi

Sharepoint Foundation 2010 to Sharepoint Server 2010

Hi there, We have Sharepoint Foundation 2010 already installed on Windows Server 2008, which uses SQL Server 2008 R2 Express (64 bit). There are sites already created and Custom lists and workflows. We then purchased a Sharepoint Server 2010 license. Is there an easy way to upgrade our current sharepoint using the same Database (Content DB). How do I deploy this new Sharepoint (on top of the Foundation) Worst case scenario: I have to remove Sharepoint Foundation and then install the licensed "Sharepoint Server 2010" version Please advise

When Upgraded a site from Wss 3.0 to Sharepoint foundation 2010, subsites are not working

HI ALL, I recently migrated an old Sharepoint site from WSS 3.0 to Sharepoint foundation 2010. There were no problems during the upgrade and the stsadm command displayed the message that upgrade completed successfully. However when I am accessing the sub-sites from outside the server, I am able to see the content, but when I go to Site Settings, I get an error "File not found". Also the Views for the sub-sites are not working. However on accessing the sub-sites from the Server everything is working fine. Can anyone please help me?  

Windows 7 Sharepoint 2010 Foundation

Hello again, we installed Sharepoint 2010 Foundation on a Windows 7 Professional OS 8GB 4Core machine and when we try to use a trial Version of Visual Studio 2010 we are getting "A 32 bit version of version of Windows Sharepoint Services is required by this project but is not installed on this system. Please install Windows Sharepoint Services 3.0, please download from MS or as part of MS Sharepoint Server 2007" I'm wondering if anyone might know if there is a key step we forgot to do or if this might be a Visual Studio 2010 setting per chance? Thanks very much again BobK  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend