|
 |
asp_databases thread: query
Message #1 by "reba begum" <begumreba@h...> on Sun, 25 Feb 2001 14:10:27 -0000
|
|
<html><DIV>
<P>following tables am using: </P>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<P>room = roomid, type, disrcription, price</P>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<P>booking = bookingid, roomid, customerid, datein, dateout<BR><BR>Am trying to create a query to search for rooms
that are available within specified dates. </P>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<P>This website- <A
href="http://64.4.8.250/cgi-bin/linkrd?_lang=EN&lah=fdd440f5427a5be330427b0a1f4343ba&lat=983110135&hm___action=http%3a%2
f%2fwww%2ebellagiolasvegas%2ecom%2fpages%2fmain_noflash%2easp%23"
target=_blank>http://www.bellagiolasvegas.com/pages/main_noflash.asp#</A> - has on-line room reservation, where when
customer selects checkin and checkout dates and it lists all the rooms that are available. Am am tying to do the same. </P>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<P>Thanks<BR><BR></P></DIV><br clear=all><hr>Get Your Private, Free E-mail from MSN
Hotmail at <a href="http://www.hotmail.com">http://www.hotmail.com</a>.<br></p></html>
Message #2 by "Ken Schaefer" <ken@a...> on Mon, 26 Feb 2001 09:56:32 +1100
|
|
Do a query that selects all the bookings between a certain date. All the
remaining dates must be free - you could use a loop to construct an array of
dates that are still free.
Cheers
Ken
----- Original Message -----
From: "reba begum" <begumreba@h...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, February 26, 2001 1:10 AM
Subject: [asp_databases] query
> following tables am using:
>
> room = roomid, type, disrcription, price
>
> booking = bookingid, roomid, customerid, datein, dateout
>
> Am trying to create a query to search for rooms that are available within
specified dates.
>
> This website- http://www.bellagiolasvegas.com/pages/main_noflash.asp# -
has on-line room reservation, where when customer selects checkin and
checkout dates and it lists all the rooms that are available. Am am tying to
do the same.
>
> Thanks
|
|
|
View Cart
