Hey all, I tried the two solutions offered, end neither of them worked.
The code is still only cycling over the first employee and simply not moving to any other employee in the database. I'm at a complete loss as to why, since the logic should be sound. -Angel -----Original Message----- From: Pascal Peters [mailto:[EMAIL PROTECTED]] This is because you always access the first record from the outer loop in the inner loop. Solution in your code below! -----Original Message----- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: maandag 21 januari 2002 16:02 To: CF-Talk Subject: Problems with looping Hey all! Take a look at this code. The idea of course, is to loop through all the employees in the table and run a particular query against each employee. _______________________________________________________ <CFQUERY name="GetEmployees" datasource="xxxxx" DBTYPE="ORacle80"> Select Employee_ID FROM Empl_General </CFQUERY> <CFOUTPUT query="GetEmployees"> <CFSET i = GetEmployees.currentRow> !!!!!!!!!!!! <CFLOOP CONDITION="#CurrentDate# LESS THAN OR EQUAL TO #EndDate#"> <CFSET CurrentDate= DateFormat(#CurrentDate#,'mm/dd/yyyy')> <CFQUERY name="GetHours" datasource="xxxx" DBTYPE="Oracle80"> Select SUM(RegHrs) AS TotalHours FROM TblMainEntry,TblDetailEntry WHERE TblMainEntry.EmpID= #GetEmployees.Employee_ID[i]# !!!!!!!!!!!!!!!!!!!!!!!!!! AND tblDetailEntry.RecordDate= to_date('#currentdate#','mm/dd/yyyy') AND tblMainEntry.MainID = TblDetailEntry.MainID </CFQUERY> <CFIF GetHours.TotalHours GT 24> #GetHours.Employee_ID#    #GetHours.TotalHours# </CFIF> <CFSET CurrentDate = DateAdd("d",CurrentDate,1)> </CFLOOP> </CFOUTPUT> _______________________________________________- ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
