Thanks. But what what you suggesting is not working. I need to display. 1 area
manager on one line and get all the calculation on one line
>You could do it better with aggregate functions, but this will work, too.
>Just make the completionDate lookup part of your base query (note the LEFT
>OU
Come on dude, you've been told before, help us by asking better questions!
What doesn't work?
Format your code so it's easy for us to see what's going on, I can't be
bothered to look through your code because it's all over the place.
If the query is correct and the problem lies in the output, w
You could do it better with aggregate functions, but this will work, too.
Just make the completionDate lookup part of your base query (note the LEFT
OUTER JOIN), and then use the GROUP attribute of the CFOUTPUT tag to do the
looping for you in one go:
Select distinct e.employeeid,
3 matches
Mail list logo
