Yes, seriously, I'll jump right behind Brian here - one schema can handle everything you need if properly designed. You're currently solving the wrong problem.
On 8/10/07, Brian Kotek <[EMAIL PROTECTED]> wrote: > Then you are definitely approaching this the wrong way. What you want to > have is a table with all the courses and a table with all the times and > rates for the courses. Having separate tables for every course is going to > be completely unmaintainable going forward. Again, I'd urge you to stop > right now and learn about database design and database normalization. There > are many good books and web sites on the subject. Ben Forta's SQL book is > very good and concise. The CF Web Application Construction Kit books also > cover this in detail. However you do it, you need to hold off on going any > further until you get a grasp on these ideas because this is critically > important when building an application that uses a database. > > Regards, > > Brian > > > On 8/9/07, Zach Firestone <[EMAIL PROTECTED]> wrote: > > > > I have to do a database for each course because each course has different > > rates for each day and time. > > > > >First, I think you might consider that the database schema you have here > > is > > >not very good. You're going to have a separate database table for every > > >course? Why would you do this? A much better option would be to have a > > table > > >of courses, with course IDs, and another table with times and dates that > > >link to a course via a foreign key. If any of this sounds unfamiliar to > > you > > >I'd urge you to stop right now and read a book or some web tutorials on > > SQL > > >and database design, because not only is the critical knowledge to have > > as a > > >developer, it is critical to creating a maintainable database structure > > for > > >this application. > > > > > > > > > > > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285937 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
