I have three tables tableA Rresources (resourceID) tableB Attributes (attributeID, attributeName) tableC ResourcesAttributesValues (ravID, resourceID, attributeID, value)
I need to apply MySQL Limit clause to get paginated dataset from row 1 - 100/101-200/201-300.... I'd like to run a single query to get 1-100... resources with all of their attributes and values. What is the most efficient way to do it? Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:328447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
