It should be noted that Verity, as included with ColdFusion MX 7, is now a
separate install. I have a bit of experience using Verity from pre
ColdFusion MX installs and not all good. For example the
www.itsanhonour.gov.au site would generally crash the "search index"
generator consistantly. Most frustrating. And not through lack of RAM
either.
But CFMX and it's search partner Verity (www.verity.com) has come a long way
in the last few years.
Ideally, you would use Verity for the indexing of physical content (not
dynamic).
If for example you have an Intranet with lots of Microsoft Word, Microsoft
Excel, Adobe Acrobat documents, etc, that can be "re-indexed" once a day
then Verity is a good choice.
If however the content is much more dynamic consider the search facilities
of your database server - or a combination of both physical/dynamic content.
And at the end of the day (non peak periods) use Verity.
I'd anticpate the new "Advanced ColdFusion MX 7 Web Application Construction
Kit" tome by Ben Forta - et al - will delve deeper into the new Verity
possibilities of CFMX 7. At least I hope so.
Admittedly it has been a while since I've had to depend on Verity as a
search engine but as I am in the process of rebuilding www.actcfug.com for
CFMX 7 I just might use both the database server (MS SQL Server) and Verity
for the best of both worlds. I might even write an article about my surely
journey through the effort!
"You can ony search on one field?" Rubbish. At least two custom fields and
who knows with the new Verity engine? Will report back when I know more.
Peter Tilbrook
ColdGen Internet Solutions
Manager, ACT and Region ColdFusion Users Group
PO Box 2247
Queanbeyan, NSW, 2620
AUSTRALIA
WWW 1: http://www.coldgen.com/
WWW 2: http://www.actcfug.com/
Telephone: +61-2-6284-2727
Mobile: 0432 897 437
E-mail: [EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis
Sent: Monday, April 04, 2005 8:26 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: Verity indexing issue
You can only search on one field cant you?
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jason Bayly
Sent: Monday, April 04, 2005 6:37 PM
To: CFAussie Mailing List
Subject: [cfaussie] Verity indexing issue
Hi Peoples,
I ve just written a site search feature for a client using verity. Its all
DB content across several tables.
Ive written a query which spans the tables (using UNION and CAST func. on
the datatypes for conformance etc) and it all runs and looks ok, except it
doesnt return all the recs in a table. When i create/refresh the catalouge
my query returns 130recs which is right, but only some of them i can search
across.
eg.. i can look at at title of one of the records in the site and then do a
search on specific words i know are in the title, i dont get any matches...
nada
Any ideas, where to begin?
My SQL look likes below... and i know its not my verity tags etc as ive used
these before without issues in a recent job.
TIA Jason
SELECT UID AS ID,
Title AS Title,
CAST(newsBodyCopy AS NVarChar(4000)) AS BC,
OBJPath AS Path,
Status AS Status,
AccessLevelIDLU AS ALevel,
newsAbstract AS Abstract,
NULL AS Date,
NULL AS Location,
NULL AS Venue
FROM TBL_NewsAwardItems
WHERE status = 1 AND AccessLevelIDLU <> 3 UNION SELECT UID AS ID,
Title AS Title,
CAST(oppBodyCopy AS NVarChar(4000)) AS BC,
OBJPath AS Path,
Status AS Status,
AccessLevelIDLU AS ALevel,
oppAbstract AS Abstract,
NULL AS Date,
NULL AS Location,
NULL AS Venue
FROM TBL_OpportunityItems
WHERE status = 1 AND AccessLevelIDLU <> 3 UNION SELECT UID AS ID,
Title AS Title,
CAST(BodyCopy AS NVarChar(4000)) AS BC,
OBJPath AS Path,
Status AS Status,
AccessLevelIDLU AS ALevel,
Abstract AS Abstract,
NULL AS Date,
NULL AS Location,
NULL AS Venue
FROM TBL_AboutItems
WHERE status = 1 AND AccessLevelIDLU <> 3
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To
unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To
unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
