contains information for online training courses.
So in the first table courseoutline they would use a html form to add
the course information to the db such as
ID = 1
Course Title =i.e. Windows 2000
Course Summary = Summary of Course in this field
Owner = automatically populated through session name variables.
Coursepath - contains word doc containing course contents uploaded via
cffile
In the second table iteccourse they would use a form to add the course
dates and availability to the db such as
CourseID = 1
Course Title = Selected from form select field populated using CF with
entries from the course title field in the courseoutline db.
Coursedate = 17 July 2004
Duration = 3 Days
Availability = Yes/ Full
Owner = automatically populated through session name variables.
Then in the detail page of the training site what coldfusion query would
be needed so that if I just wanted to view upcoming Windows 2000 courses
it would bring back the related coursepath for that course ??
Any ideas on the best way to achieve this - or could my table schema be
improved ??
I appreciate your views and help
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
