.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

Custom Search WebPart issue with apostrophe

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :SharePoint

I have a custom search webpart which returns the results based on the search input from a text box. The search is performed on a managed property called "CustomerName". When the customer name has apostrophe " ' " in its text, the search results are not returned because of the wrong query formation. 

I need to use a escape sequence and pass the search query. Can anyone help me how to form the query for this ?

Example: Customer name : A'BCD

View Complete Post

More Related Resource Links

Custom Search issue with freetext


Hi All,

My Environment : MOSS 2007 (sp2) with SQL Server 2005

I have a custom search webpart which uses FullTextSqlQuery to fetch the results from Index. I have a some keywords and a free text boxt to build the search query. Poeple enter their query by selecting the keywords and enter some free text into the text box.

Issue : When any PDF document (Not tested with .Doc) is searched using custom webpart with the numbers like "2,0233.21" I do not get any results returned even though the results are returned using the SharePoint out of box full text search. But when I search the content like "2+0233+21" I get results both in Out of box and in custom search webpart.

Requirement: The Custom search should be able to find the document when numbers like "2,0233.21" are entered. It should work exactly like the out of box search.

Thanks in advance for your suggestions.



Multilingual Interface (Hindi) custom, webpart issue disappearance in share point 2007

Hi This is regarding the disappearance of custom  web parts in the multilingual site developed using MOSS 2007. The multilingual feature has been implemented using variations. All the custom web parts disappear when viewed after some time.  When the custom web parts are deployed to the site, it appears and they disappear when viewed after some time.  I have done local deployment as well as GAC deployment of the web parts dll. Both have the same effect. I have added the respective resource files for the web parts in the user control folder.    Thanks In Advance uttam  

How can I add custom Search Paging webpart in the Search results page in MOSS 2007


I have created a Basic webpart page and added Content editor webpart to extend the functionality of Advanced Search webpart. This is working fine. Also added OOB Search Paging webpart int his page. But when the number of items returned by the Search Core results webpart exceeds the Page size (10) then when I click on the next link in the Paging webpart then all results are lost and retrieved from All Sites scope. Is there any way to hook into the Search paging webpart.?

Please note that in the Content Editor webpart I have used custom search scope.

I need help with regard to this.

Thanks in advance!.

How to develop a custom search webpart in MOSS 2007


Hello All,

I have a requirement where i need to develop a custom webpart in sharepoint 2007. The functionality of the webpart is to search the sql database  tables and display the results based on the sql queries.
Can anyone point me in the right direction to build out one custom search webpart.

Do i need to use consumer-proivder webpart to do that. Beacause i wanted to show the results in a separate grid on the same page.

Any pointers are greatly appreciated.

Thank you,


Custom Webpart connecting to Search core results webpart




I want to connect custom webpart (custom search box) to the Search Core results webpart.


Please let me know how to achieve this.


Thanks in advance.


Custom search webpart


Hi All,

I am creating a custom advaced search webpart.I wantd to show the results in search center results.aspx page.

So i am sending the keyword and property values as a query string to results.aspx page.

I am able to get the proper results, ut the problem here is in the search box i am aslo seeing the property and value passed in the query string. 

Eg:Testing "Author":"MSDN" Name":"Sudan"

Is there any way to restrict it.or is there a better way to develop a custom adavced search web part (not using query string)?

Custom controls and ViewState management issue



I want to know that when we create custom controls, then is there State Management through ViewState done automatically or we have to handle it explicitely ?Since i have created Custom Controls that is behaving as if it is not maintaining its state on PostBack.

Error in / Application after adding employee search in webpart


Hello everyone,

I am working on sharepoint 2007 and I was editing the webpart of the software and after adding the predefined employee search table, the server has crashed while trying to access the server remotely with the following error message:

Error in / Application

However, while trying to login locally I have no problem and can easily login.

What will be the course of action in fixing this error.

Also the site is complaining of an invalid certificate even after adding an exception.

Any help would be greatly appreciated.

Thank You,

Chris Stanko

Unable to search Custom User Property Created in User Profiles in SharePoint 2010


Hi ,

I have created a custom user property,and created metadata property and added mapping to it, still i m not able to Search in People,Please advise

Search Server Gatherer - Custom hierarchical protocol handler ISearchProtocol for MOSS 2010



Search server gatherer calls CloseAccessor() and shutdown() on ISearchProtocol after GetChunk() even if the FILTER_E_END_OF_CHUNKS is not returned. After calling shutdown() it stops calling the createaccessor() with new URL. I want to create a hierarchical indexing but I am not gatherer is not suporting this. The same piece of code is working fine in MOSS 2007, I am facing this issue in MOSS 2010 only. Is there anything changed in MOSS 2010 which is creating this issue?



Create a Outlook Task from Custom WebPart in Code



I have a requirement to create a Outlook Task , from a custom webpart through code .

Is this possible?

has any body tried this , if yes can you please give me an insight on how to acheive it.

Some sample Code would be highly appreciated.



QueryEx (Search) results and Custom Page Index


Hi All,

I done a web part which allow the user to query the search.asmx. It return the result fine against which I apply some xslt. However I need a mean to create a Page index. I only return the result based on a range defined in the query.

I need somehow to obtain the number of result the search is returning in total against what I only want to display on the screen.

The only way I sort of figure to do that is by first make a search just to obtain the number of result it will return in total and then make a search defining a range.

Has someone done something similar?


Issue with Web capture webpart configuration


I have a requirement to display a specific are of page.
I think we can do it by using web capture webpart. when i try to modify the properties of webcapture webpart it prompts an message"Cannot create or modify Web Capture. Make sure that your browser supports ActiveX controls , that you have enabled them, and that you have installed the Web Capture ActiveX control".
I have installed "owc11" coponent but of no use. i am using IE 7...

can anyone please suggest how to solve this issue?


Search Scope Issue



I have 8 web applications containing different sites. One of the web applications is hosting a site called pmsportal.

Currently search results display files from all sites and from all web applications having matching results. That is like google!!! Sweet!!! BUT its over-performing! The owners of the pmsportal want search results to display only results from within their site ONLY...how do I do that? In the SSP Search Settings I have only two(2) Content Sources defined

(1) Local Office SharePoint Server sites

(2) PeopleSoft_Data

Someone please help.

Video: Creating Custom Ranking Models in SharePoint 2010 Search

In SharePoint search you can tune the weighting that search uses for the results and create custom ranking models to return the results the user is expecting. (Length: 2:28)

DateTime custom managed property search fails with " Your query is malformed. Please rephrase your q

I've created a front end search page in Silverlight 4 for SharePoint Search.  Currently we are using WSS 3.0 + Search Server Express 2008 (v  The page interacts with the MOSS version of the search web service at:   <site collection>/_vti_bin/search.asmx The reason for this approach is the unique way the requirements specify the look and behavior of the results.  The built-in Search Center page or web parts will not satisfy these requirements. We are going into production but I still cannot figure out how to search against my custom managed properties that are of Type DateTime.  If I cannot get this to work, it is a showstopper. I've tried numerous variations on the SQL Syntax and cannot get it to work.  I know the error is in the date portion of the WHERE clause since I can remove it and searches work fine. Here is a working query: SELECT Size, Rank, Path, Title, Description, Write, RequestSubmittedDate, DocumentType, RequestPromisedDate, ProblemDescription, DatePublished, RequestOwner, RequestingDepartment, DocumentAuthor, ProjectNumber, ProjectDescription, RequestStatus FROM scope() WHERE CONTAINS ('"nmr"') ORDER BY "Rank" DESC yet if I try to use a date literal in the WHERE clause as in the following query modification, I get the "malformed"

"Mixed mode assembly is built against version 'v2.0.50727'.... " issue and use custom config file

Hi, My Winform applilcation has used Microsoft.SqlServer.Management.Common namespace(assembly :Microsoft.Sqlserver.smo.dll/Microsoft.Sqlserver.ConnectionInfo.dll) and developed in .NET 4.0. Problem:Application is throw an exception when it tries to use above assembly reference methods. Full error text is shown below, "Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information. " Error is resolved when we include "app.config" file with below code, <?xml version="1.0"?> <configuration> <startup useLegacyV2RuntimeActivationPolicy="true"> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/> </startup> </configuration> But, I need to keep configuration file as "renamed.config" and not to include app.config file as of the project requirement.I have set configuration file as "renamed.config" file using below code, //AppDomain.CurrentDomain.SetData("APP_CONFIG_FILE", "d:\\reanmed.config" ); I have also included <Startup> element in this "renamed.config" configuration file and removed the app.config file.But it raise me below error, it always expect app.config file with <Startup> element to resolve this iss
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