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. if I select where primary key > 1000 then primary key 1001 through 1051 are missing etc etc etc the recordcount always shows 51 more records than is in the collection. I've even tried to loop through the cfquery/cfindex to only add 100 records at a time. during the first part of the loop, everything seems to work fine, but about the 25% mark it begins to drop the first 51 records and the collection always ends up with 51 records less than the database query. > 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. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283350 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
