Re: Next and Previous on grouped output
Hi Thanks for you response, i downloaded and set up pagination.cfc, however this still uses the main query to get the total record count, when using with grouped ouput the wrong page amounts are retuned. However, i must say easy to use and setup! Jason >Have you looked at this? >http://paginationcfc.riaforge.org/ > > >On Tue, Jun 2, 2009 at 7:53 AM, Jason Congerton >wrote: > >> ~| 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:323082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Next and Previous on grouped output
Have you looked at this? http://paginationcfc.riaforge.org/ On Tue, Jun 2, 2009 at 7:53 AM, Jason Congerton 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. > > > 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 = value="#get_websites.wa_websiteID#"> > > > > > > > ~| 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
Next and Previous on grouped output
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. 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 = ~| 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:323067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4