Assuming we're talking about searching a database here, what I did (before
I went to SQL Server Full Text) was to perform the Verity search to find a
list of IDs whose records matched the Verity Search query, and then perform
a standard SQL search, a la:
<CFQUERY ...
standard SQL statements here....
WHERE ID IN (ValueList.VerityQueryName.IDcolumn)
</CFQUERY>
to match the SQL requirements.
It was not as fast as SQL7 full text on the same data. (Don't know about
CF5 K2)
best, paul
At 06:48 PM 6/13/01 +0200, you wrote:
>Even if there would, It'll be inefficient because in order to use CFSEARCH
>you will need
>to rebuild the Verity Index to match the last SQL query, but if you don't
>plan to change
>the original SQL content (i.e - the first query result set) - you absolutly
>can do it.
>
>just create a new collection and index the result set -
>I think the whole process is called.... search... ;-)
>
>Thanks,
>
>Michael
>----- Original Message -----
>From: "Steve Vosloo" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, June 13, 2001 4:00 PM
>Subject: Verity & SQL
>
>
> > Is there any way to combine the results of a CFSEARCH and a standard SQL
> > search into the same CFOUTPUT ... basically merge two queries?
> >
> > Thanks
> > Steve
> >
> >
> > Development Manager
> > Vardus Internet Solutions (SA)
> >
> > Tel: (+27) 21 670 9880
> > Fax: (+27) 21 674 4549
> >
> > Email: [EMAIL PROTECTED]
> > Website: www.vardus.com
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
