Lemme, how would I solve that...?
By hiring you?
Sorry - it's late and I'm way too tired. ;^)
However it sounds to me like the first system is easily converted to the
second ("Dec 10th 2004 - 15th has 200 rooms" is also "Dec 10 has 200 rooms,
Dec 11 has 200 rooms, etc).
Doing that you've eliminated the problem of having dual systems when
determining placement making it a non-issue.
Of course I could be missing something big.
Jim Davis
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of Brian LeRoux
> Sent: Thursday, December 04, 2003 2:59 AM
> To: [EMAIL PROTECTED]
> Subject: [CFCDev] Fun design problem
>
> My client manages confrences for doctors, engineers and the sort. A
> confrence has a number of sponsoring hotels they'll end up working with.
> The hotels give the organizing body of the congress room blocks.
> Specified by a date range and quantity of rooms available. For example:
> Dec 10th 2004 - 15th has 200 rooms. However, sometimes a hotel will give
> the quantity for single days like so: Dec 10 2004 has 3 rooms, Dec 11
> 2004 has 4 rooms, etc. One hotel will use either booking system but not
> both. When a person registers to attend the confrence they choose their
> accomadations: hotel, checkin date and checkout date-- where you'll have
> to validate against the "inventory" (not to mention the dates are within
> the right ranges).
>
> Now I solved this to my satisfaction but with so much interesting
> discussion here lately I wanted to hear how *you* would approach this
> one. I'm sure my solution could use work. :)
>
>
> ----------------------------------------------------------
> You are subscribed to cfcdev. To unsubscribe, send an email
> to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev'
> in the message of the email.
>
> CFCDev is run by CFCZone (www.cfczone.org) and supported
> by Mindtool, Corporation (www.mindtool.com).
>
> An archive of the CFCDev list is available at www.mail-
> archive.com/[EMAIL PROTECTED]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email
to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev'
in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported
by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
