Hello! I have a page setup that lists data about certain records in a DB2 database.
The user can choose between two different methods of showing data. The first (ONLY Mode) shows orders for a specific account. (This is working fine) The second "mode" (Called Normal) shows all of the order for the specific account along with orders from the parent company and any other children companies associated with the parent company. This is working fine except for the "paging" feature. The user can page back an forward to see a user defined amount of records on each page. I've modified the code so that it properly shows "Showing 1 - 20 of 913 Next 20". But, it is listing the first 20 of the first query and then the first 20 of the second query. Then when the user clicks next it shows the next 20 of each query. How to I take two queries and combine them so they paging will work? Should I use an array and stick all of the results into this array? Thanks for any direction. Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
