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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Advanced text search...

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server
 

See requirement examples below.... any suggestions / ideas are helpful....

I am using SQL server 2005 and I have a limitation that I should not use full text search.

I have a table with nvarchar(100) column which holds data. Users will enter search terms on text box with predefined grammar. See examples below.....

1. BEFORE operator

"intersection before(n) car" finds intersection when it precedes car by n terms, where n is the nearness value

2. NEAR operator

"intersection near(n) car" finds intersection within n terms of car, where n is the nearness value

 




View Complete Post


More Related Resource Links

Advanced text search...

  
See requirement examples below.... any suggestions / ideas are helpful.... I am using SQL server 2005 and I have a limitation that I should not use full text search. I have a table with nvarchar(100) column which holds data. Users will enter search terms on text box with predefined grammar. See examples below..... 1. BEFORE operator "intersection before(n) car" finds intersection when it precedes car by n terms, where n is the nearness value 2. NEAR operator "intersection near(n) car" finds intersection within n terms of car, where n is the nearness value  

Filter search over multiple text columns

  

Hi everyone,

I'm working on a library that stores information on various cases. The case table has several columns that contain descriptive strings on what happened in the case. I would like to create a single filter that returns all cases where the search string is found in any of the columns. I've looked at Dynamic Data Filtering, but as far as I can tell, the "Contains" filter only allows you to connect to each column individually. Has anyone tried this?

Thanks,

Andrew


Full text search in a Word document

  

Hello,

  I´m currently programming a web search application in ASP.Net and having problem with full text searching. My requirements are:

1. Save a byte array from SQL server to word document as a temp file in a server side?

2. How to highlight the string I am currently searching in the Word document and return to the user the sentence with the highlighted string (like on Bing or any other search engines)? Is it possible to fullfill this requirement with full-text search integrated in SQL Server 2008?

Thanks in advance,

Regards,


Lam

 


Advanced Search page no found

  

Hello,

Currently when a user attempts to conduct an advance search they recieve a page not found message. When I tried to conduct a search myself I was able to enter in my search term, but the search results came up as page not found. On closer inpection I noticed that it is droping part of the URL.

e.g.

http://sitesp.ca/sites/PETL-EPFT/searchcenter/Pages/Advanced.aspx becomes http://sitesp.ca/sites/PETL/searchcenter/Pages/Advanced.aspx

Has anyone seen this before? Any help would be greatly appreaciated.

Thanks


Search does not find text in Word document stored in document library on a Report Center site within

  

Hello,

We have a document library on a site created off of the Report Center site template. We uploaded a Word 2007 document with the word zebra in the text. Using the search bar at the top of the page we selected This list: Our document library and searched for zebra. We received no results.

We tested the same thing on another site (site template Team site) within the same site collection and search worked fine.

Does the Report Center search function differently then the search functionality on the Team site?


Tamara Bredemus SharePoint Minion...working up to Maven

full-text search error

  

I have created procedure for full-text search and it works in SQL Management Studio 2008 (SQL Server 2008 Express) but in Visual Studio 2010 not - I have error:

Full-Text Search is not installed, or a full-text component cannot be loaded.

I have read somewhere that only admin can use full-text indexes - so how I can use full-text search in VS2010 ?


Search text handling

  
Please advise how the search text boldfacing and URL list is constructed in the following example: http://www.asp.net/search?q=MVC Thanks.

Advanced People Search

  
Hi All, I'm having a problem with the Advanced People seach webpart, one of the fields under 'Search Options' is Memberships. I have updated it inline with this article http://support.microsoft.com/kb/935196, which now brings back results when searching by using a distribution list name, but I'm still getting no results when searching by a Site Name (as displayed under in the "Memberships" webpart on a mysite) Also is there a way to change the word "Memberships" in the webpart, to something like "Site Memberships"

Text Search Strategy Question for the SSIS Gurus...

  
BACKGROUND: As I have mentioned in some of my other posts I am using SSIS 2005 to replace an existing MS Access 2003 / VBA based ETL engine which I developed some years back.   Part of my existing Access-based ETL performs a text search of the source records and I am now attempting to replicate that functionality in SSIS (replicate in terms of the end-result and not necessarily the methods used to get to that end result).  I have an idea of how I plan to go about this but since am relatively new to SSIS so would greatly appreciate the feedback of those more experienced... DETAILED DESCRIPTION: In the source (Sybase ASE15) database, there is an "object" table (not the actual table name but for illustrative purposes it will suffice).  Within the object table there is a "description" column which is a char(60) datatype.  The description column simply represents a description of the object as defined by the source system end-user. For my ETL solution I allow the ETL administrator to define one or many (1...n) key words or phrases which represent search criteria.  These search criteria are stored in a reference table in my target SQL Server 2005 database (the same database to which my ETL will transform results and store them).  My objective, is as follows:  For each of the 1...n search criteria defined, try and find th

Behavior of advanced search

  
Hi, when searching by properties in the advanced search, for example by "authotr equals Danny Din" - should it find also items which contain the word Danny Din in the body of the item, or only in the metadata of the item?  

Advanced Search tiff files sharepoint 2010

  
hi, I have a question about advanced search in sharepoint 2010 would love if you could help me: I have a document management system that contains files of different types. Performing a standard search system finds documents, Advanced search performed on the document properties the system can not find such documents tiff. We installed ifilter tiff by the following link: http://www.borghoff.com/post/2010/04/02/Windows-TIFF-IFilter-and-SharePoint-2007.aspx But it does not work. Maybe you have another solution for me? Thank you.

Dynamic scope for advanced search

  
Hi all, Is there possible for us to use dynamic scope or url as the filter in the advanced search? I want to search only to specific document library or some site while if I'm using global scope I will need to define a lot of scopes. anybody can give me some clue how I can make it works? thank youBest regards, -- Pingkan --

How to add advanced search and results to the site?

  
I have a site with advanced search Box webpart. I would like to results to open to the same site with the search webpart. Not in the search center. I tried to add Search Core Results, but said results are available. Either no query is specified, or the query came from advanced search (Federated Webparts do not support Advanced Search queries).   How to do? Kenny_I

Full Text Search Return no Result while "Like" does

  
Someone pls look at the picture and help me I tried Restart the serviceI tried restart the server But the number of row affected is still zero :(

Custom advanced search form

  
Hi all, I've got some requirement which related with the advanced search form. I'll need to make a tree view which listed the site subsites and document library inside each site. For example:  sites A       DocLib 1       DocLib 2       subsites B              DocLib 3              DocLib 4       subsites C              DocLib 5              DocLib 6 Also I want to make the node which is selected as the scope for search. Is there any body can give a clue or pointer how I can make this? Any insight is appreciated.. Thank you Best regards, -- Pingkan --

Advanced search box webpart customization

  
Hi, I add the Advanced search box web part on to a page and if I uncheck any of the check box in edit mode, the search wouldn’t work and throw a JavaScript error like “'***TextBox.value' is null or not an object” ·         Show "All words" search box ·         Show "exact phrase" search box ·         Show "any words" search box ·         Show "none of these words" search box It looks like a bug of sharepoint 2010, I am not sure if anyone see this before? Is there a walk around for that?
Categories: 
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