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. > > > > > > > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285907 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
