!!! Calendar / Date / Array / Query problem
Posted on 2004-10-07
Here's the app def:
Its an approval site for time. User enters how much hours they worked overtime.
Manager logs on and can approve or reject.
I need to be able to add the number of hours for each day and print it out for that day for each employee
I have the following query:
<!--- grabs all approved users info --->
<CFQUERY DATASOURCE="lieu" NAME="lookup">
SELECT to_char (zdate, 'mm/DD/yyyy hh24:MI') as zdate,
to_char (time, 'mm/DD/yyyy hh24:MI') as zTime,
title, id, comments, status, type, user_id
WHERE zdate LIKE '%#UCase(DateFormat(ThisCalMonth, "mmm-yy"))#%'
How do I alter the SQL statement so that it sums up the number of hours entered (zdate - time) per day for each user_id??