473,700 Members | 2,569 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 6046
"dave" <dy@onlinelg.co m> 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 programmaticall y. 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_fulltextsea rch.asp

Full-Text Search Deployment
http://support.microsoft.com/default...ntent/2000pape
rs/fts_white%20pap er.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(Quanti tyPerUnit, 'boxes')
AND CONTAINS(Produc tName, ' "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.co m>
Sender: "dave" <dy@onlinelg.co m>
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: AcNuTShlfeGHyHV SRxi87UgM86a6xw ==
Newsgroups: microsoft.publi c.dotnet.genera l
Path: cpmsftngxa06.ph x.gbl
Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.genera l:106614
NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
X-Tomcat-NG: microsoft.publi c.dotnet.genera l

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.co m>
Sender: "dave" <dy@onlinelg.co m>
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: AcNtgbvzzGwymmJ QSSSulVTwnwBngw ==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.publi c.dotnet.genera l
Path: cpmsftngxa06.ph x.gbl
Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.genera l:106423
NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
X-Tomcat-NG: microsoft.publi c.dotnet.genera l

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
1399
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 * FROM Categories WHERE CONTAINS(*,'Met*')" I am getting zero results. 'Met*' appears in more than 1000 times in table Categories, but I also used many other keywords without any results also. No errors in Log, for buliding the Catalog, everything ran fine.
7
2108
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 - nvarchar lenth-30 NOTES - nvarchar length-250 Select * from database where NOTES like '%something%' Is there a way to get results from this query in less then 1-2 second
3
1668
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 you know of any 3rd party api's that are good for this? I would like to index the content, provide a search interface to search the content. I also want to have the searchable index seperate from any install (transferrable to a user if they are offline). SQL Server full text is not available for...
6
4748
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 executed when an error occurs. Any help would be much appreciated. Thanks in advance
2
2186
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 found is Google's Search Appliance but it's an expensive hardware solution and we prefer a software solution. In the past I've used development languages that had OEM Verity support which was wonderful but as far as I can tell the only out-of-the-box search available in ASP.NET is Index...
5
555
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 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
1
1234
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 etc. I am receiving the following error: Execution of a full-text operation failed. A clause of the query contained only ignored words. I tried a lot to sort out this issue,but this is going to be out of my scope. If anybody can help me then it would be really appreciable.
0
1759
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 tblContent INNER JOIN #keywords ON tblContent.words LIKE '%' + #keywords.keyword + '%' But I can not seem to do this using the CONTAINS syntax. eg.
0
1705
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 requirement that we need to return results which match a particular sequence in word. ex: The search text column has the word as 0203456-345567 if we give the input as " 0203456", the result is coming and showing the above column, but if we search for " 203456" no results return,
0
8648
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9081
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8929
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7816
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6564
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5904
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4408
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4660
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2395
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.