J/K of course.
At 06:06 PM 6/16/2004, you wrote:
>On Wed, 16 Jun 2004 15:59:23 -0500, Frank Dewey wrote:
> >
> > I'm looking into searching a website for a particular string or
> > occurence of a string. I would like for this to be an advanced search
> > (what I am looking for is something more complex than a simple LIKE).
>
>Verity?
>
> > In the database - QBOS_HELPFILE (id, name,keywords) - I am storing a
> > list of words separated only by spaces. And I am starting out with this
> > query:
> > SELECT *
> > FROM QBOS_HELPFILE
> > WHERE keywords LIKE '%#form.words#%'
>
>How many times do we have to say CFQUERYPARAM?
>
>Also, which database engine?
>
> > I've tried separating the words by commas and using the IN operator, but
> > that only works if the field (keywords) contains one word
>
>Show us your code, you have to do several LIKE statements
>
> > Maybe a combination of the In operator and LIKE depending on the search
> > text - if the search text has quotes or not. Of course the text should
> > be first parsed. I'm not sure what the best way to go about this is.
> > Are their some good examples out there? I've looked at Verity a
> > little...but I'm not sure that is what I need.
>
>Verity is MUCH more powerful than a simple LIKE - why wouldn't it do
>what you need?
>
>If you're using SQL Server, then you might want to look at Full Text Indexing
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
