Re: Nested database loops and completing an unordered list....

On 03/01/2012 06:20 PM, Jay Blanchard wrote:

[snip] Can you show the output of the function above? [/snip]

Doesn't this SQL query return everything that has company_id set to 3 which would it not contain all the data from the other queries combined into one large data set? At this point, I don't believe you have shown your output. Please show the output of your function.

0 SELECT DISTINCT TIER1DATA FROM POSITION_SETUP WHERE COMPANY_ID = '3' Executives and Management Normally this query alone returns 9 rows of data. Each of these rows should be included in the next query where TIER1DATA = each of the nine in succession 1 SELECT DISTINCT TIER2DATA FROM POSITION_SETUP WHERE COMPANY_ID = '3' AND TIER1DATA = 'Executives and Management' Executives and ManagementLeadership 2 SELECT DISTINCT TIER3DATA FROM POSITION_SETUP WHERE COMPANY_ID = '3' AND TIER2DATA = 'Executives and ManagementLeadership' Executives and ManagementLeadershipManager 3 SELECT DISTINCT BUSTIER1DATA FROM POSITION_SETUP WHERE COMPANY_ID = '3' AND TIER3DATA = 'Executives and ManagementLeadershipManager'

    Knee

4 SELECT DISTINCT BUSTIER2DATA FROM POSITION_SETUP WHERE COMPANY_ID = '3' AND BUSTIER1DATA = 'Knee'

     KneeDIV01

5 SELECT DISTINCT BUSTIER3DATA FROM POSITION_SETUP WHERE COMPANY_ID = '3' AND BUSTIER2DATA = 'KneeDIV01'

      KneeDIV01DEPT02

6 SELECT DISTINCT BUSTIER4DATA FROM POSITION_SETUP WHERE COMPANY_ID = '3' AND BUSTIER3DATA = 'KneeDIV01DEPT02'

       KneeDIV01DEPT02GRP04

7 SELECT DISTINCT ` FROM POSITION_SETUP WHERE COMPANY_ID = '3' AND BUSTIER4DATA` = 'KneeDIV01DEPT02GRP04' 1054 Unknown column '' in 'field list'

-- Jim Lucas http://www.cmsws.com/ http://www.cmsws.com/examples/ http://www.bendsource.com/