Hi,
I need some search system, that will return me the records with in indicator
of probability. This is for a VB.NET 2005 application with a SQL Server 2000
DataBase.
I have a table with different columns in which the user needs to search. In
case the search-routine finds the exact match (the same part of the
sentence) it should return that record with a 100%-indicator. If it finds
all the words in it, but not in that order: 75%-indicator. If it find only
some words in it: 50%-indicator. If it finds only some parts of some words
in it: 25%-indicator.
You can see this sometimes on websites that allow you to search for
keywords.
I can't find any sample code for this, and I don't know exactly how to
implement this. It should be as fast as possible! Should I do this at
DataBase-level, or read the whole table in my VB.NET-application and perform
the Search there?
Any help, hits, samples, ... would be great!
Thanks a lot in advance,
Pieter 3 1630
Hi,
Take a look at FreeTextTable and ContainsTable sql queries. http://msdn.microsoft.com/library/de...fa-fz_1f51.asp http://msdn.microsoft.com/library/de...ca-co_3syt.asp
Ken
-----------------------
"Pieter" <pi**********@hotmail.com> wrote in message
news:u0**************@TK2MSFTNGP09.phx.gbl... Hi,
I need some search system, that will return me the records with in indicator of probability. This is for a VB.NET 2005 application with a SQL Server 2000 DataBase. I have a table with different columns in which the user needs to search. In case the search-routine finds the exact match (the same part of the sentence) it should return that record with a 100%-indicator. If it finds all the words in it, but not in that order: 75%-indicator. If it find only some words in it: 50%-indicator. If it finds only some parts of some words in it: 25%-indicator.
You can see this sometimes on websites that allow you to search for keywords.
I can't find any sample code for this, and I don't know exactly how to implement this. It should be as fast as possible! Should I do this at DataBase-level, or read the whole table in my VB.NET-application and perform the Search there?
Any help, hits, samples, ... would be great!
Thanks a lot in advance,
Pieter
Wow! At first sight this seems something very powerfull! I'll need to take a
closer look at it!
Just a pitty that it seems to work only on Tables, not on views? Or is it
possible to use it on a View when the underlying tables contain it?
Thanks a lot!
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:ud**************@TK2MSFTNGP10.phx.gbl... Hi,
Take a look at FreeTextTable and ContainsTable sql queries.
http://msdn.microsoft.com/library/de...fa-fz_1f51.asp
http://msdn.microsoft.com/library/de...ca-co_3syt.asp
Ken ----------------------- "Pieter" <pi**********@hotmail.com> wrote in message news:u0**************@TK2MSFTNGP09.phx.gbl... Hi,
I need some search system, that will return me the records with in indicator of probability. This is for a VB.NET 2005 application with a SQL Server 2000 DataBase. I have a table with different columns in which the user needs to search. In case the search-routine finds the exact match (the same part of the sentence) it should return that record with a 100%-indicator. If it finds all the words in it, but not in that order: 75%-indicator. If it find only some words in it: 50%-indicator. If it finds only some parts of some words in it: 25%-indicator.
You can see this sometimes on websites that allow you to search for keywords.
I can't find any sample code for this, and I don't know exactly how to implement this. It should be as fast as possible! Should I do this at DataBase-level, or read the whole table in my VB.NET-application and perform the Search there?
Any help, hits, samples, ... would be great!
Thanks a lot in advance,
Pieter
This seems to work fine in most cases, but one very important case it
doesn't: When the user has typed only a part of the word, it doesn't work.
For instance: If you repalce in the query "bread" with "bre" it doesn't
return all the records with "bre" in it.... any idea how to add wilcards to
this?
USE Northwind
SELECT FT_TBL.CategoryName,
FT_TBL.Description,
KEY_TBL.RANK
FROM Categories AS FT_TBL INNER JOIN
FREETEXTTABLE(Categories, Description,
'sweetest candy bread and dry meat') AS KEY_TBL
ON FT_TBL.CategoryID = KEY_TBL.[KEY]
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:ud**************@TK2MSFTNGP10.phx.gbl... Hi,
Take a look at FreeTextTable and ContainsTable sql queries.
http://msdn.microsoft.com/library/de...fa-fz_1f51.asp
http://msdn.microsoft.com/library/de...ca-co_3syt.asp
Ken ----------------------- "Pieter" <pi**********@hotmail.com> wrote in message news:u0**************@TK2MSFTNGP09.phx.gbl... Hi,
I need some search system, that will return me the records with in indicator of probability. This is for a VB.NET 2005 application with a SQL Server 2000 DataBase. I have a table with different columns in which the user needs to search. In case the search-routine finds the exact match (the same part of the sentence) it should return that record with a 100%-indicator. If it finds all the words in it, but not in that order: 75%-indicator. If it find only some words in it: 50%-indicator. If it finds only some parts of some words in it: 25%-indicator.
You can see this sometimes on websites that allow you to search for keywords.
I can't find any sample code for this, and I don't know exactly how to implement this. It should be as fast as possible! Should I do this at DataBase-level, or read the whole table in my VB.NET-application and perform the Search there?
Any help, hits, samples, ... would be great!
Thanks a lot in advance,
Pieter
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Craig Cockburn |
last post by:
Hi
I'm aware of the use of robots.txt and the use of <META NAME="ROBOTS"
CONTENT="index,follow">
However, what would be more useful is to be able to control within a
page which elements of...
|
by: cybit friendly |
last post by:
Hi
I'm stuck due to lack of knowledge.
Problem: I'm scanning through Array1 to find the closest match
to Array2 within Array1. At the moment I'm using a method that can
best be described as...
|
by: Andreas Schmitt |
last post by:
Hi,
Sorry for posting in German before, totally forgot about that when I was
pasting this in here from another German newsgroup I was writing to, trying
to get help
I am programming a simple...
|
by: Mayank Kaushik |
last post by:
hi everyone,
im trying to create a function that generates a 1 or a 0, with the
probability of a 1 being generated equal to X (which is passed to the
function as a parameter).
any ideas?...
|
by: Pieter |
last post by:
Hi,
I need some search system, that will return me the records with in indicator
of probability. This is for a VB.NET 2005 application with a SQL Server 2000
DataBase.
I have a table with...
|
by: Peter Rilling |
last post by:
If anyone has experience with DotLucene, then this question might be right
up your alley.
I have two lists of music titles. Each from a different source. I am
trying to match determine...
|
by: Elliot Temple |
last post by:
Problem: Randomly generate 10 integers from 0-100 inclusive, and sum
them. Do that twice. What is the probability the two sums are 390 apart?
I have code to do part of it (below), and I know how...
|
by: Arun Nair |
last post by:
''' Can anyone help me with this program it just takes probability of
the first team and runs the program doesnt takes the probability of the
second team even though specified'''
from random...
|
by: coolguyraj |
last post by:
I have a PHP and javascript code to take value from two text boxes and calculate on triggering the "OnBlur" function and display in the third box.
The code works fine with one line item,If i have...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|
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,...
|
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...
| |