My 2 cents on the matter would be: Any reason you need to split up the tables in the first place? With a slightly different table design you can store everything in one table, and it's trivial to retrive only records from a certain year.
+=======================+ | user_id | year | month | hours | +=======================+ Chrs, Dav On 4 Sep 2008, at 15:07, Wole wrote: > > I'm developing a time sheet application that needs to dynamically > create database tables and the associated model. The application first > creates a database table that looks like this: > > +======================================================+ > | id | jauary | february | ... (and so on).... > | december | > +======================================================+ > > Where id stores a user name, january stores the user's hours for > January, feburary stores the user's hours for February, etc. Each > table would be named <year>_time_sheets, where <year> is the current > year, e.g. 2008_time_sheets. This would keep all users' time sheet > data organized by year then organized by month in each table. > > Creating this database table is something I can do using the query > function. The problem I'm running into is how do I dynamically create > a model to handle the data in each <year>_time_sheets table? Right now > I have a generic model called TimeSheet that I use to get data from > the time sheet form. But, because there is no 2008TimeSheet model I > can't save the data to my dynamically created 2008_time_sheets > database table. > > I would really appreciate any help provided or if someone can tell me > a way to do this without dynamically creating a model. Thanks. > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
