Hi
I need a search engine to put in one of my forms and it is supposed search
an access table (containing song lyrics), and searches it based on keywords
(the standard search engine type like in windows). Somebody must have made
something like this (and made it available for free download) or what?
Vegard
Timbuck2 - 07 Sep 2003 16:45 GMT
Use replace to replace all non alpha chars in the lyric
with nothing
replace double and triple spaces with one space
use split to split on spaces
With each word insert into IndexTable the word
on fail who cares the word is only needed once.
in LyricsToWords table insert WordID and LyricID
Many lyrics to many Words through LyricsToWords
Searches will be much faster on Words you can provide list
of lyrics containing words.
>-----Original Message-----
>Hi
[quoted text clipped - 7 lines]
>
>.