Ken, Just to clarify, you're trying to get summary data on leave items, right? Like this:
Joe: Vacation: 10 | Sick: 15 With a date range and stuff too, but that's the basics, right? J On Sat, 25 Dec 2004 22:19:18 -0500, Ken <[EMAIL PROTECTED]> wrote: > Thanks Jared. I am simply looping through the records using <cfoutput > query="abc"> > > Also, i just tried your select statement and i am still getting the > exact same recordset. Here's what I am doing now: > > SELECT FirstName, LastName, Email, LeaveLogID, EmployeeID, Leavetype > FROM employee LEFT OUTER JOIN SASCalendar ON > employee.EmpID = SASCalendar.EmployeeID > where ApproverID=10005 AND (YearMonth like '%12' and YearMonth like '2004%') > order by employeeID, yearMonth, leaveType > > Any ideas? should i be using Q of Q? If so, please guide. > > Thanks, > Ken > > On Sat, 25 Dec 2004 20:22:26 -0600, Jared Rypka-Hauer - CMG, LLC > <[EMAIL PROTECTED]> wrote: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188789 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
