Answer - I just checked Admin/Verity Collections and do not see a way to see the document count. I've been getting the "recordssearched" by doing a cfsearch without the criteria and then a cfdump.
> Question - how are you checking the size of the verity collection? I > assume you are checking in the admin, looking at Document Count, > right? > > On 7/9/07, John Stottlemire <[EMAIL PROTECTED]> wrote: > > the key field in the cfindex = the primary key of the database table > (I don't think its duplicate keys). > > > > I purge the collection, do the query, update the collection and the > difference in recordcount / recordssearched is always recordcount - > 51 > > > > the primary key is an "identity" and increments by 1. if I order by > primary key desc then the first 51 primary key records are missing > from the collection, if I order by primary key asc then the last 51 > primary key records are missing from the collection. > > > -- ======> ===================================================================== > Raymond Camden, Camden Media > > Email : [EMAIL PROTECTED] > Blog : ray.camdenfamily.com > AOL IM : cfjedimaster ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283396 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

