How about a table like this: Boat startdate enddate A 4/18/2003 4/20/2003 A 4/26/2003 4/27/2003 A 5/17/2003 6/22/2003 B ... ...
Startdate to enddate is the contiguous set of dates that the boat runs. You can select it like Select distinct boat from table where #userdate# between startdate and enddate Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 3:26 PM To: CF-Talk Subject: Application design question Monday, January 13, 2003, 3:24:34 PM Hello cf-talk, Hey everyone. I've got a schedule of boat rides;there are three boats, and the rides run at certain dates and different tours. I've been given a Word document of the 2003 schedule and for example, it lists: Boat A. April 18, 19, &20 April 26/27 May 17-June 22 June 25-october 19 ..and so forth. There are also 2 other boats with fairly similar schedules. What I'd like to do, is get the schedule info into a database table so a user on the website can just select a date from a form, and then the site will show what boats are running on that date. I can imagine the long way to do this would be to create a record for each day of the operating summer and fill in what is available on that date. Is there a better method? Any ideas?? I'd love to give each boat a table, but then how to add dates? Possible to get a date from a form, then somehow be able to select what's available based on the dates when the dates can be ranges? I'm just brainstorming, and could use any ideas anyone may be able to offer! Jeff Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
