Hey Ray, The document count from Verity matches the total in the db: 799.
I've tried most of the other types of searches, including simple, and still no dice, it only returns 25 records for the specific search. The document that highlighted this problem contains 'stable' or 'stables' 3 times, so I would expect verity to pick it up, but it is not returned in the search. And I hear you on the refresh and like statements, they were mostly used for trying to figure out this issue. Tyler On 8/29/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > > 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"? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
