Probably Simple Solution for getting looping results

Hey mplungjan,

Unfortunately it's a little more complex than that, I'll try and step through it.

I have a job that has 3 tasks, the 3 tasks can have different or the same priorities.

I wish to display all open jobs one after the other (this is the first ASP SQL loop) then in each line for each job I wish to display the most urgent priority in the 3 tasks so therefore there is a 2nd ASP SQL loop to check all three tasks to get all three priorities (which I currently can display as 1,2,3 for example) and then display only the most urgent.

I hope that makes sense, therefore it's nested loops (I don't think it helps using access as a backend but thats out of my hands.

Thanks in advance
Neilos

Sorry, that does not make enough sense for me to understand how to code that in asp...

If I am not mistaken, you get only priorityIds back from your sql so I do not understand where the jobnames would be coming from unless you forgot to tell me about the sql that gets the jobname...

Hopefully this might make it clearer, I have the following code:

<%
      set rs = objConn.execute ( "SELECT JobShellID, JobShellName, ClientID, ClientName, JobType, StatusID, WorkDate, DateEntered FROM TblTempNew" & Session("USERNAME") & " WHERE JobType='" & strJobTypeDrop & "'" & strOrderBy )  

        do until rs.eof or rs.bof
%>
<%=JobShellName%>, <%=ClientID%>, <%=JobType%>, <%=StatudID%>, <%=Workdate%>, <%=DateEntered%>,
<%
set rsPr = objConn.execute("select distinct priorityid from qryjobtasks where jobshellid=" & rs("JobShellID") & " and statusid <> 1 " )
%><%      
      do until rsPr.eof or rsPr.bof
      strPriorityAll = rsPr("priorityid")
%>
<%=rsPr("priorityid") & "," %> <---- This Code Here is the issue (I think)
<%
       rsPr.movenext
       loop
                      rsPr.close      
%
<%
        rs.movenext
        loop
      rs.close      
%>      

Hopefully you will have noticed my note saying'<---- This Code Here is the issue (I think)' above.  Basically we have two loops, one nested in the other, the internal one is collecting several records about one field, e.g. 3 tasks it returns with varying priorities.  I'd like to be able to recognise the highest priority and display just that and ignore the other results.  Is it possible?

Thanks in davance again
Neilos

You are as your rank suggests, a guru...thanks a million!  I'll post the finished code next of the inner loop for your reference if required.