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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

