IF creating the index for dynamic pages is all that's holding you up, look a little
deeper into Verity (although i'm not sure it's what you need overall). You CAN index
dynamic pages that are generated from different tables and/or datasources, static
pages, and uploaded documents, and all three can be combined into one index to create
a powerful search capability. That's how we handle search functionality on all our
projects.
:) n.
-----Original Message-----
From: Frank Dewey [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 6:20 PM
To: CF-Talk
Subject: RE: advanced search
Thanks guys for helping me with this. I looked more in Verity. Verity
only looks at static pages. Since my page is generated dynamically by
the database at runtime, this option will not work. I'm still kinda new
to CF and so didn't know about CFQUERYPARAM...but I do now :-)
I am using Microsoft SQL Enterprise Manager. After the user enters
there string, then I am going to parse it for " (Double quotes - of
course there must be two), - (minus sign - for NOT), and + (addition
sign - for AND). By default, the words will be separated by spaces and
an OR operation will be applied to them.
Then I am thinking about using some combination of LIKEs, Full Text
Indexing, and/or cfqueryparam. Of course I want the application to run
fast so I might nix the LIKE '%#word#%'.
Thanx again for the help -
Frank
________________________________
From: Frank Dewey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 16, 2004 3:59 PM
To: CF-Talk
Subject: advanced search
Hello all,
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).
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#%'
I've tried separating the words by commas and using the IN operator, but
that only works if the field (keywords) contains one word
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.
Are there any suggestions/help on this matter that ya'll can help me
with? Thank you -
Frank
-----------------------------------------------------------
The Preceeding Email Has Been Scanned
and Verified By QBOS Security Systems
-----------------------------------------------------------
QBOS, Inc.
14275 Midway Rd. Suite 220
Addison, TX 75001
972.233.5066
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
