Hi,
Sorry for the x-post
I was wondering if anyone has an idea as to how I can do this. Currently I
have a task system whereby you can allocate jobs to users, we have a table
that can record that you are 0ut of the 0ffice for a specified time, I need
to workout if a user is 0ut of the 0ffice between Now() and a deadline so
that an administrator can be informed... Currently I have this as a query
SELECT *
FROM 0ut0f0ffice
WHERE UserID = 6
AND (0ut0f0fficeFrom <= {d '2003-06-06'}
AND
0ut0f0fficeTo >= {d '2003-06-10'})
Now this works if you are 0ut of the 0ffice between now and the deadline in
one go.
i.e. 05/06/2003 - 13/06/2003 - Seminar.
But if a person sets up their out of office like this:
05/06/2003 - 08/06/2003 - Seminar 1
09/06/2003 - 13/06/2003 - Seminar 1
They are 0ut of the 0ffice and so cant get the task done, but the above
query wont pick this up therefore cannot inform anyone.
Has any one got any ideas as to how to tackle this?
BTW if the users OOO setup is something like..
05/06/2003 - 06/06/2003 - Seminar 1
09/06/2003 - 13/06/2003 - Seminar 1
Then they are in the office at some point therefore could do the task so I
don't want this to be included in the query...
TIA
Mikey
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
