1 Reply Latest reply on Jul 10, 2007 3:23 PM by virtually_john

    Verity Recordssearched NEQ Recordcount

      doing a cfindex using type = custom, action = update and the appropriate queryname with ColdFusion MX 6.1 with updater:

      the query.recordcount = 2631
      the cfsearch.recordssearched = 2580
      the cfindex is executed immediately after the cfquery

      no matter how the "order by" statement is within the sql statement the first 51 records of the recordset are always missing from the verity collection. AS an example, order by key desc leaves currentrow 1-51 out of the index, order by key asc leaves currentrow 1-51 out of the index.

      Can anyone shed any light on why this might be happening?