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? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283590 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
