| 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> |
|---|---|---|
| ||
| Previous by Date: | Re: DB2 Issue, DanielOlds |
|---|---|
| Next by Date: | Re: Table I'm building, Dan Bracuk |
| Previous by Thread: | Update query in Access, semi star gazer |
| Next by Thread: | Re: Table I'm building, Dan Bracuk |
| Indexes: | [Date] [Thread] [Top] [All Lists] |