<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Oh Baby, It's So Hot When You Paginate! (aka Paginating Results In ColdFusion) Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:281.view Date Posted: Sep 21, 2006 at 1:21 PM ---- --------------------------------------------------------------------------------------- ---> SELECT b.id FROM blog_entry b INNER JOIN display_status d ON ( b.display_status_id = d.id AND d.is_active = 1 AND d.is_listed = 1 AND b.date_posted >= AND b.date_posted < AND b.date_posted >= AND b.date_posted < AND b.id IN ( SELECT btjn.blog_entry_id FROM blog_entry_tag_jn btjn WHERE btjn.tag_id = ) ) ORDER BY b.date_posted DESC, b.time_posted DESC, b.id DESC