Maybe its duplicate keys. Are you saying that if you EMPTY your collection, do a query that returns N rows, and then cfindex that query, your collection contains N-52 records?
On 7/9/07, John Stottlemire <[EMAIL PROTECTED]> wrote: > can anyone shed some light on why a cfindex would exclude the first 51 > records from a query recordset no matter what the order by statement says in > the sql statement. > > my query.recordcount is always 51 records more than the query.recordssearched > and its always the first 51 records from the query result that are missing. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:283345 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
