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 1175
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: kpp9c |
last post by:
Greetings,
I am working on a program to produce patterns. What would like is for
it to exhaustively produce all possible permutations of a sequence of
items but for each permutation produce...
|
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: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
| |