ASP.NET and SQL 2000 FULL Text Search Results

[dave]

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

 

[Dominique Kuster]

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/evaluation/features/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.

 

[Tian Min Huang]

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/default.asp?url=/library/en-us/dnsql2k/htm
l/sql_fulltextsearch.asp

Full-Text Search Deployment
http://support.microsoft.com/default.aspx?scid=/support/sql/content/2000pape
rs/fts_white%20paper.asp#IndexC

SQL Server 2000 Books Online
http://www.microsoft.com/sql/techinfo/productdoc/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.

 

[Vikrant V Dalwale [MS]]

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.

--------------------

 

[Vikrant V Dalwale [MS]]

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.

--------------------