<html><DIV>
<P><BR><BR></P></DIV>
<DIV></DIV>
<DIV></DIV>
<P>Thanx Ken for your reply. </P>
<P>I need feedback to use loop to construct an array of the dates that are still free. The book am using does not go in detail
with arrays. </P>
<P>==========================</P>
<DIV></DIV>>Do a query that selects all the bookings between a certain date. All the
<DIV></DIV>>remaining dates must be free - you could use a loop to construct an array of
<DIV></DIV>>dates that are still free.
<DIV></DIV>>
<DIV></DIV>>Cheers
<DIV></DIV>>Ken
<DIV></DIV>>
<DIV></DIV>>----- Original Message -----
<DIV></DIV>>From: "reba begum" <BEGUMREBA@H...>
<DIV></DIV>>To: "ASP Databases" <ASP_DATABASES@P...>
<DIV></DIV>>Sent: Monday, February 26, 2001 1:10 AM
<DIV></DIV>>Subject: [asp_databases] query
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> > following tables am using:
<DIV></DIV>> >
<DIV></DIV>> > room = roomid, type, disrcription, price
<DIV></DIV>> >
<DIV></DIV>> > booking = bookingid, roomid, customerid, datein, dateout
<DIV></DIV>> >
<DIV></DIV>> > Am trying to create a query to search for rooms that are available within
<DIV></DIV>>specified dates.
<DIV></DIV>> >
<DIV></DIV>> > This website- http://www.bellagiolasvegas.com/pages/main_noflash.asp# -
<DIV></DIV>>has on-line room reservation, where when customer selects checkin and
<DIV></DIV>>checkout dates and it lists all the rooms that are available. Am am tying to
<DIV></DIV>>do the same.
<DIV></DIV>> >
<DIV></DIV>> > Thanks
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>---
<DIV></DIV>>Please take a moment to tell us how you are using AuthentiX, WebQuota, and
<DIV></DIV>>VideoQuota
<DIV></DIV>>
<DIV></DIV>>http://www.flicks.com/feedback/feed.asp
<DIV></DIV>>
<DIV></DIV>>Scott Gordon
<DIV></DIV>>Marketing
<DIV></DIV>>Flicks Software
<DIV></DIV>>www.flicks.com
<DIV></DIV>>310-526-0325
<DIV></DIV>>---
</html>
View Cart
