Will nay of these utilities help? http://livedocs.adobe.com/coldfusion/6.1/htmldocs/verityu2.htm
On 7/13/07, John Stottlemire <[EMAIL PROTECTED]> wrote: > The result of this page is always a failure to index the first 51 records in > the recordset. I've had my order by set to ASC then to DESC and then changed > the field I was ordering by and always the first 51 records within the > recordset are not being indexed by the cfindex. (Always where currentrow gt 0 > or lt 52) > > The query will dump all the records desired and none of the keys are > duplicates (as table_id is the primary key of the table) nor are any of the > fields NULL, so I'm certain it isn't a sql statement error. > > > Could this be caused be a failure when joining tables? Maybe there > > is not record in TABLE2 that goes with TABLE1. So more records would > > be searched than returned. Perhaps try a LEFT JOIN? > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:283640 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
