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
