472,328 Members | 2,142 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,328 software developers and data experts.

ASP.NET and SQL 2000 FULL Text Search Results

I am wondering if the following can be done.

I want to setup a search page that utilizes full text
searching in sql2000. I want the user to type in
say "where is bill" and have the query search across
multiple columns in multiple tables and return a single
list of results so that i can show unique records that
are returned.
The problem is that my data for 1 record is split across
multiple tables so that the search has to occur in each
table but still only return unique/distinct records.
I hope this makes sense.
Can anyone help on how i can accomplish this?
thank you in advance
dave
Jul 19 '05 #1
4 5957
"dave" <dy@onlinelg.com> wrote in message
news:02****************************@phx.gbl...
I am wondering if the following can be done.

I want to setup a search page that utilizes full text
searching in sql2000. I want the user to type in
say "where is bill" and have the query search across
multiple columns in multiple tables and return a single
list of results so that i can show unique records that
are returned.
The problem is that my data for 1 record is split across
multiple tables so that the search has to occur in each
table but still only return unique/distinct records.
I hope this makes sense.
Can anyone help on how i can accomplish this?
thank you in advance
dave

It could be a candidate for MSSqlServer English Query.
http://www.microsoft.com/sql/evaluat...es/english.asp
"With English Query, the user can create applications that accept
natural-language queries, questions written in plain English, instead of
complex SQL queries."
I don't know this technology but I would be interested to know if it applies
to this case.

Jul 19 '05 #2
Hello Dave,

Thanks for your post. I suggest that you can use Full-Text Search for each
table, and then combine the result programmatically. I believe the
following MSDN documentations are helpful:

Building Search Applications for the Web Using Microsoft SQL Server 2000
Full-Text Search
http://msdn.microsoft.com/library/de...us/dnsql2k/htm
l/sql_fulltextsearch.asp

Full-Text Search Deployment
http://support.microsoft.com/default...ntent/2000pape
rs/fts_white%20paper.asp#IndexC

SQL Server 2000 Books Online
http://www.microsoft.com/sql/techinf...2000/books.asp

Hope this helps.

Regards,

HuangTM
Microsoft Online Partner Support
MCSE/MCSD

Get Secure! C www.microsoft.com/security
This posting is provided as is with no warranties and confers no rights.
Jul 19 '05 #3

Hello Dave,

You are right about AND operator in CONTAINS and CONTAINSTABLE Predicate
where <Search Condition1> AND <Search Condition2>
will be TRUE only if both conditions are in the same column mentioned in
the predicate. However if you mention * insead of the column name
then search condition with AND operator applies to all the columns which
are candidates for FTS.

However, for FREETEXT AND FREETEXTABLE , the <free text string> does not
recognize AND as a boolean operator and you can't use it.

For AND operation where search conditions in the same expression exists in
diff columns of the table, you need to implement it using a Sql Query.

E.G,

USE NORTHWIND
GO
SELECT ProductName
FROM Products
WHERE UnitPrice = 15.00
AND CONTAINS(QuantityPerUnit, 'boxes')
AND CONTAINS(ProductName, ' "choc*" ')
GO

Please let me know if that answers your question.

Thanks for posting to MSDN Managed Newsgroup.

Thanks,

Vikrant Dalwale

Microsoft SQL Server Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Get secure !! For info, please visit http://www.microsoft.com/security.
Please reply to Newsgroups only.

--------------------
Content-Class: urn:content-classes:message
From: "dave" <dy@onlinelg.com>
Sender: "dave" <dy@onlinelg.com>
References: <02****************************@phx.gbl> <F3**************@cpmsftngxa06.phx.gbl>Subject: RE: ASP.NET and SQL 2000 FULL Text Search Results
Date: Fri, 29 Aug 2003 09:46:56 -0700
Lines: 11
Message-ID: <01****************************@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcNuTShlfeGHyHVSRxi87UgM86a6xw==
Newsgroups: microsoft.public.dotnet.general
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.general:106614
NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
X-Tomcat-NG: microsoft.public.dotnet.general

I read the following somewhere on the web...

For Contains and ContainsTable you are correct. The
boolean AND will only work when both hits are in the same
column. For FreeText and FreeTextTable the query and
boolean operators can look across columns.

Is the something wrong with the above approach?
thx
dave


Jul 19 '05 #4

Hello Dave,

Please let us know if you need any further assistance on this issue.

Thanks for posting to MSDN Managed Newsgroup.

Vikrant Dalwale

Microsoft SQL Server Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Get secure !! For info, please visit http://www.microsoft.com/security.
Please reply to Newsgroups only.

--------------------
Content-Class: urn:content-classes:message
From: "dave" <dy@onlinelg.com>
Sender: "dave" <dy@onlinelg.com>
Subject: ASP.NET and SQL 2000 FULL Text Search Results
Date: Thu, 28 Aug 2003 09:30:46 -0700
Lines: 15
Message-ID: <02****************************@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcNtgbvzzGwymmJQSSSulVTwnwBngw==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.dotnet.general
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.general:106423
NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
X-Tomcat-NG: microsoft.public.dotnet.general

I am wondering if the following can be done.

I want to setup a search page that utilizes full text
searching in sql2000. I want the user to type in
say "where is bill" and have the query search across
multiple columns in multiple tables and return a single
list of results so that i can show unique records that
are returned.
The problem is that my data for 1 record is split across
multiple tables so that the search has to occur in each
table but still only return unique/distinct records.
I hope this makes sense.
Can anyone help on how i can accomplish this?
thank you in advance
dave


Jul 19 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Wizard! | last post by:
I built a catalog for a table. Ran the Full-Population, and having >5.000.000 items count, > 5.000 unique key count. However when I ran "SELECT *...
7
by: nydefender | last post by:
I have one table with 300,000 records and 30 columns. For example columns are ID, COMPANY, PhONE, NOTES ... ID - nvarchar lenth-9 COMPANY -...
3
by: Leneise44 | last post by:
I'm coding an asp.net app that will be using web services for the data access layer. I want to implement a full text search of my PDF content. Do...
6
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being...
2
by: Samuel R. Neff | last post by:
What options are available for doing full-text searches of database data without using a database-specific full-text engine? The only option I've...
5
by: dave | last post by:
I am wondering if the following can be done. I want to setup a search page that utilizes full text searching in sql2000. I want the user to type...
1
by: Rathorevivek | last post by:
Hi All, I have been using full text search in my application for search purpose. But on certain words i.e Noise Words such as And,After,About...
0
by: Skywick | last post by:
Hi I am trying to do a full text search with a column name for the search term. I can do this using LIKE with: SELECT tblContent.ID FROM...
0
by: padmajapenmetsa | last post by:
Hi, We have the full text search table and are using CONTAINSTABLE to search in the fulltext search column, its workingfine, but we have a...
0
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
1
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.