Hey group, I'm creating a search interface for my users, and due to the potential number of records being returned by the searches, I really need to use "Next N" browsing to display the returned records. However, since I cannot use more than one query with "Next N" browsing, I either need to find a way to combine my queries into one, or find an alternate navigation method that will allow more than one query in the results. The situation is this: I am pulling almost all of the information from a table called MAIN. However, there is a "Regions" column (VARCHAR) in the table that stores numbers in a comma-delimited format (e.g. '2000,3110,4300'). What I need to do is somehow pull the actual menu item name from the REGIONS reference table to correspond with each ID number in the MAIN.REGION list. BUT, I need to do this all in ONE query to use Next N browsing. So, does anyone have any ideas as to how I can either combine these queries to pull both the information from MAIN and from REGIONS, OR, does anyone have an alternate record navigation idea that would allow me to use multiple queries in the results? Thanks! Terri ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
