Not knowing the details of your problem it is almost impossible to make a
reasonable recommendation, however here is the approach I use.
1. Build the custom field with whatever info you need to search on. I
generate the output between cfsavecontent tags, strip out the html tags, and
then save it in the custom field.
2. When you use cfsearch just grab the primary key from verity and then use
stored proc to get the information. I don't use the verity fields for
display at all.
Don Vawter
www.cyberroomies.com
[EMAIL PROTECTED]
----- Original Message -----
From: "Robert Everland" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 10:48 AM
Subject: Verity Search engine problems
> I have this query that is huge and unmanageable so I have been given
> the task of trying to speed it up. So I put it over to a verity collection
> and it's a lot lot lot faster, but it doesn't do me any use because all
the
> tables are now one big thing in the body. So my question is this, I figure
I
> can use the custom field stuff, but there are only 2 of those, is there a
> way to have more custom fields, say a full blow version of verity if it's
> possible, and where is the syntax I can use to go though this thing. It
> seems even though my SQL query is unmanageable at least I can get what
data
> I need from it.
>
> Robert Everland III
> Dixon Ticonderoga
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
