[thelist] sql and databases

[Andrew Martin]

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!
> -- 
>
>
>
> -- 
>
> News! - Evolt.org conference for web professionals.
> 17-19 September 2004 in Toronto, Canada.
> Details at http://TOevolt.org
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>