Have you looked at this? http://paginationcfc.riaforge.org/
On Tue, Jun 2, 2009 at 7:53 AM, Jason Congerton <[email protected]>wrote: > > Hi > > I have query which joins together four tables, in my output i use group to > display the correct information to the screen. > > The query returns around 42 records of which 13 are being displayed to the > screen, code below; (i'll tidy up .* when i get it working) > > My question is how to do next and previous, my normal method falls short, > because of the grouping as it uses the record count of the query to know > where it is. > > I have had a look around for some examples, with no luck so far. If any one > can pint me in the right direction - thank you. > > <cfquery name="get_global_products" datasource="#application.dsn#"> > SELECT wp_products.*, gp_product_templates.*, wa_websites.*, wp_images.* > FROM ((gp_product_templates INNER JOIN wp_products ON > gp_product_templates.gp_id = wp_products.wp_product_template_id) INNER JOIN > wa_websites ON wp_products.wp_product_web_id = wa_websites.wa_websiteID) > LEFT JOIN wp_images ON wp_products.wp_products_id = > wp_images.wp_gp_product_id > WHERE wp_product_web_id = <cfqueryparam cfsqltype="cf_sql_integer" > value="#get_websites.wa_websiteID#"> > </cfquery> > > <cfoutput query="get_global_products" group="gp_name"></cfoutput> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323069 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
