>
> 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]
