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 -~----------~----~----~----~------~----~------~--~---
