Category: MySQL 5
CFM codesnippet: navigation through large datasets with mySQL (SQL_CALC_FOUND_ROWS)
By Ruben on Feb 1, 2007 | In ColdFusion, MySQL 5 | Send feedback »
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 »
Inexpensive setup: Railo (ColdFusion), OpenLaszlo, Red5, MySql, CentOS
By Ruben on Nov 16, 2006 | In ColdFusion, Linux Hosting, MySQL 5, Red5 flash server, Railo, OpenLaszlo | Send feedback »
As a stiff ColdFusion developer since 1999 I've closely followed all developments in webworld from the angle 'Allaire, Macromedia and Adobe'.
During these years I've noticed that technology has become cheaper and many times even free.
Picture t… more »