Hello Scott, On Mon, 13 Jan 2003, at 13:33:53 you carefully wrote: >>Boat A. >>April 18, 19, &20 >>April 26/27 >>May 17-June 22 >>June 25-october 19
SB> Just off the top of my head: SB> 1) A table for boats that has a record for each boat. SB> 2) A table for trips that includes the boat_id, the departure date, and the return date. SB> To get the info for a certain date, you could do this: SB> SELECT b.boat_name, t.departure, t.arrival SB> FROM boatTbl b, tripTbl t SB> WHERE SB> b.boat_id = t.boat_id SB> AND t.departure <= <cfqueryparam value="#yourDate#" cfsqltype="CF_SQL_DATE"> AND t.arrival >>= <cfqueryparam value="#yourDate#" cfsqltype="CF_SQL_DATE"> SB> ORDER BY SB> t.departure, t.arrival, b.boat_name SB> I think that should get you started (unless someone has a better suggestion, which is possible). Of course, the database you're using will affect the actual query syntax. SB> Scott I see this working. What worries me the the trips table. I'm hoping to avoid entering a new record for each trip, for each boat. Could I somehow use a range? some of the trips run each day from June to October. I'd love to find a way around entering hundreds of records for each trip. But, I can't think of a way. Jeff ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
