a
> master-servant relationship (I know the word is not servant - just can't
> remember)
>
> -J
>
>
>
> Reply Separator
> Subject:RE: Verity & SQL
> Author: [EMAIL PROTECTED]
> Date: 6/13/01 6:03 PM
>
> Hi Jaso
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:
to match the SQL requirements.
It wa
This is one of the reasons I went to SQL Server 7 full text search.
It's easy and faster to combine full text search with standard SQL.
best, paul
At 11:19 AM 6/13/01 -0400, you wrote:
> > Is there any way to combine the results of a CFSEARCH and a
> > standard SQL search into the same CFOUTPUT
Hi Jason,
Thanks for the help. This is a great solution - which I've already tried
(also from pg 733 :-) ... but to no avail.
Basically, I've inherited a database from an existing site and when I index
the data everything works fine. Then when I add new records and re-index,
they are not include
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
> Is there any way to combine the results of a CFSEARCH and a
> standard SQL search into the same CFOUTPUT ... basically merge
> two queries?
You can do that very easily with the query-a-query functionality in CF 5. In
CF 4.x, you can do this by building a query object using the CF query
functi
The verity Search97 Information Server is still a good product.
(I think they have version 3.7 out)
Although very poorely supported by it's own frontend.
The search capabilities and the vast amount of parameters you can change
makes it
a good product for me.
The Verity-integration with ColdFusion
7 matches
Mail list logo
