Archives for: February 2007

CFM codesnippet: navigation through large datasets with mySQL (SQL_CALC_FOUND_ROWS)

Codesnippet: Following code uses CFM + MySQL to select a part of all available records from a table. But also use 'SQL_CALC_FOUND_ROWS' to obtain the total amount of records in the table. This way you can make page navigation through large datasets.… more »