Page design recommendation wanted

**Cowboy \(Gregory A. Beamer\)** · Oct 14 '08, 08:55 PM

Re: Page design recommendation wanted

First, you will probably want to denormalize the database a bit so it has a
concept of what a week is. Then finding non-booked items is as easy as

SELECT * FROM Items
WHERE ItemID not in (SELECT ItemID FROM Bookings WHERE BookingWeek =
@bookingWeek)

You would then supply the booking week parameter to the mix.

This works provided a week is always linear and there is no overlap.
Otherwise you use dates.

If you have to go by dates, you can do it, but the query gets a bit more
complex. You also have to make sure you keep bookings in the system
properly.

I would google and see if you can find a schema diagram for a booking
system. I would imagine there is at least one out there. You might even luck
out and find a sample open source project. Even if you do not use all of the
code, seeing how it is done is a great learning exercise.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog

Stop Making Sense

http://feeds.feedburner.com/GregoryBeamer#

or just read it:

Stop Making Sense

http://feeds.feedburner.com/GregoryBeamer

*************** *************** **************
| Think outside the box! |
*************** *************** **************
<staeri@gmail.c omwrote in message
news:23e37594-8d3f-42d2-bf9e-d93e08628b38@m3 2g2000hsf.googl egroups.com...

I'm going to show free weeks in a booking system in a grid.
>
The user needs to be able to select which cities and products should
be included in the search of free weeks and I need help with designing
this in a user friendly way. There are about 10 cities and 100
products.
>
How would you design this?
>
I'm looking forward to your reply!
>
// SE

Page design recommendation wanted

Page design recommendation wanted

Comment