[thelist] sql and databases
Ken Schaefer
ken at adOpenStatic.com
Fri Aug 13 21:38:25 CDT 2004
You do not need Index Server. SQL Server has the same technology built in -
check Books Online.
Cheers
Ken
----- Original Message -----
From: "Andrew Martin" <comitque at hotmail.com>
Subject: Re: [thelist] sql and databases
: Yeah, that's a good idea. How about Index Server? I haven't used it
before
: (and I have no idea how useful/useless it may be) but I do have access to
: it.
:
: Thanks!
:
: ----- Original Message -----
: From: "Peter Brunone (EasyListBox.com)" <peter at easylistbox.com>
: To: <thelist at lists.evolt.org>
: Sent: Friday, August 13, 2004 3:12 PM
: Subject: RE: [thelist] sql and databases
:
:
: >
: > Is this a SQL Server database? You might look into full-text
: > searching.
: >
: > -----Original Message-----
: > From: thelist-bounces at lists.evolt.org
: > [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Andrew Martin
: >
: > I am working on a site for a record store. They have a database full of
: >
: > artist names and album titles.
: >
: > Using ASP, I currently use LIKE as a sql term, so SELECT * WHERE artist
: > LIKE
: > '%" & searchterm & "%'"
: >
: > If someone searches for "JOHNNY CASH AND THE FUNKY FRESH BAND" and the
: > actual artist title is JOHNNY CASH WITH THE FUNKY FRESH BAND, no results
: >
: > appear.
: >
: > "johnny cash funky fresh" also would not turn up any results because
: > that
: > exact phase is not in the database.
: >
: > How do I perform a more complicated search? Are there tutorials
: > anywhere
: > for this?
: >
: > Thanks!
More information about the thelist
mailing list