macromedia.coldfusion.database_access
[Top] [All Lists]

Table I'm building

Subject: Table I'm building
From: "Winston2" <webforumsuser@xxxxxxxxxxxxxx>
Date: Tue, 20 May 2008 17:47:12 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access

I am creating a "Class" table to hold training class information for my 
company. Some classes are held on a single date. Others are held on multiple 
dates like 5/12 - 5/16. Some are held over a two week time frame. All are held 
on business days, no weekend dates. How should I record this? At first I 
thought about putting in fields labeled Date1, Date2, etc but then I had second 
thoughts that might not be the best way. Can anyone give me some advice on 
this? I am using CF8 and SQL Server 2000. 

 The fields that I have in my "Class" table thus far are:

 ClassID
 VendorID
 InstructorID
 ...



 Thanks very much.


<Prev in Thread] Current Thread [Next in Thread>