Hmm, I wonder if that was added to CF8 then. Try running CFCOLLECTION action=list, and tell me what doccount you see there.
On 7/10/07, John Stottlemire <[EMAIL PROTECTED]> wrote: > 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 robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
