Just to be clear - a refresh will delete existing data before adding - so are you completely refilling the collection again? If you check the document count, does it match what you think it should?
LIKE searches are not the same as Verity searches. For example, where lower(name) like '%ray%' will match Boray, Raymond, and Ray. Also, the internest_basic search may not be what you want to use. Did you try "simple"? On 8/29/07, Tyler Silcox <[EMAIL PROTECTED]> wrote: > I'm having some issues with Verity returning limited results. I'm submitting > a query to a custom collection using the cfindex tag with a refresh action. > If I search the verity collection that is populated by the query, I only > receive 25 results. But, if I use a query of queries with a LIKE command to > search the populating query, during the same request, I receive 99 results. > > I'm searching for a simple keyword "stable" in lowercase using > "internet_basic" or "internet" type. My prior experience with Verity has > been positive, but this is just making me think Verity is dropping the ball? > Any ideas? > > Tyler > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
