Thanks for the feedback and I agree with you, Matt and Dave in the design of a start and end date if these were events. I guess misspoke because the entries in these tables really are not events, but time report activities. Below is an example of some data already in the application.
(Entry_ID, Time, Reason, Date, User, PostBy, Postdate)
35 0.5 Meeting 5/15/2006 SW4694 SW4694 5/15/2006 2:21:57 PM
36 0.5 Meeting 5/15/2006 RX6982 RX6982 5/15/2006 2:22:24 PM
37 0.25 Meeting 5/15/2006 SW4694 SW4694 5/15/2006 2:52:40 PM
38 0.75 Meeting 5/15/2006 EG3798 EG3798 5/15/2006 2:28:14 PM
39 0.75 Meeting 5/15/2006 PW6146 PW6146 5/15/2006 2:29:00 PM
40 7.5 Vacation 5/12/2006 TW8286 TW8286 5/15/2006 2:29:03 PM
41 0.75 Meeting 5/15/2006 DA4391 DA4391 5/15/2006 2:31:22 PM
42 2 Vacation 5/15/2006 DA4391 DA4391 5/15/2006 2:31:50 PM
43 0.75 Meeting 5/15/2006 TW8286 TW8286 5/15/2006 2:34:47 PM
44 0.5 Meeting 5/15/2006 DW8464 DW8464 5/15/2006 2:35:18 PM
Hopefully the data comes across as readable. But as you can hopefully see most of the entries are not for full days. Most them are for meetings for 30 mins or 45 mins.
What I am looking to do is give the manager the ability to enter in multiple entires at one time. So she can put in a half hour meeting everyday for the next 3 days. I have the function and form already made, I'm just struggling on where to put it in my "OO" design.
Am I thinking too much into this? Am I making it too complicated?
Ryan
On 6/15/06, Robert Gatti <
[EMAIL PROTECTED]> wrote:
Ryan,
You said in your example that there would be five entries in the DB
because of the date span. Why not just modify your table to include an
EndDate field. Events that were only on a specific day would have the
StartDate be the same as the EndDate. Then each Bean would more
logically map to a single table record.
Robert
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
--
Ryan Everhart
[EMAIL PROTECTED]
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
