|
 |
asp_databases thread: show calendar bookings
Message #1 by "clover c" <callisto137@h...> on Wed, 28 Nov 2001 11:49:50 +0000
|
|
Hello all,
Need some help with a booking/calendar type asp effort i'm working on.
The general principle is that a user can book one of 4 meeting rooms on a
specified date.The times of booking are between 07:00 am and 07:00pm and a
list of these times is displayed against each room name in 15 minute
increments.
What im trying to do is show at what times and for what time span a specific
room is already booked out for.(i.e. if the room is unavailable the cell
containing that time should be shaded)
The fields in the database as it currently stands are:
tblBookedRooms
--------------
strRoomCode
strMeetingTitle
dtmDateOut
dtmTimeOut
dtmTimeIn
I'm at a loss as to how to extract the correct time and link it to a cell in
the table of times (!). Further, How might I address the 15 minute increment
problem, say for example if someone books a room from 2pm to 3pm how might I
highlight 2pm, 2:15,2:30 and 2:45??
I hope this makes sense, I've had a lot of coffee.
Any help would be great, TIA.
Clo
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Message #2 by Sam Clohesy <sam@e...> on Wed, 28 Nov 2001 16:12:56 -0000
|
|
I think there was a 4guys article that did some of the stuff you are after:
http://www.4guysfromrolla.com/webtech/060599-2.shtml
And there is stuff on asp101.
Thanks
Sam
Sam Clohesy
Project Manager
Tel: 0208 772 3958
E: samc@e...
W: http://www.etypemedia.co.uk
-----Original Message-----
From: clover c [mailto:callisto137@h...]
Sent: 28 November 2001 11:50
To: ASP Databases
Subject: [asp_databases] show calendar bookings
Hello all,
Need some help with a booking/calendar type asp effort i'm working on.
The general principle is that a user can book one of 4 meeting rooms on a
specified date.The times of booking are between 07:00 am and 07:00pm and a
list of these times is displayed against each room name in 15 minute
increments.
What im trying to do is show at what times and for what time span a specific
room is already booked out for.(i.e. if the room is unavailable the cell
containing that time should be shaded)
The fields in the database as it currently stands are:
tblBookedRooms
--------------
strRoomCode
strMeetingTitle
dtmDateOut
dtmTimeOut
dtmTimeIn
I'm at a loss as to how to extract the correct time and link it to a cell in
the table of times (!). Further, How might I address the 15 minute increment
problem, say for example if someone books a room from 2pm to 3pm how might I
highlight 2pm, 2:15,2:30 and 2:45??
I hope this makes sense, I've had a lot of coffee.
Any help would be great, TIA.
Clo
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
Message #3 by David Cameron <dcameron@i...> on Thu, 29 Nov 2001 10:20:05 +1100
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C17863.36C4D810
Content-Type: text/plain
Is this an ASP question or a SQL question?
For asp, (in pseudo code)
Do ' Loop through rooms
' Write room name
Do ' loop through possible times
if (currenttime > rs("starttime") and currenttime < rs("end
time")) Then
' Write the time in red to show it is booked
else
' Write the normal time
End If
Loop
Loop
currenttime holds the time that you have got to in your 2nd loop.
regards
David Cameron
nOw.b2b
dcameron@i...
-----Original Message-----
From: clover c [mailto:callisto137@h...]
Sent: Wednesday, 28 November 2001 9:50 PM
To: ASP Databases
Subject: [asp_databases] show calendar bookings
Hello all,
Need some help with a booking/calendar type asp effort i'm working on.
The general principle is that a user can book one of 4 meeting rooms on a
specified date.The times of booking are between 07:00 am and 07:00pm and a
list of these times is displayed against each room name in 15 minute
increments.
What im trying to do is show at what times and for what time span a specific
room is already booked out for.(i.e. if the room is unavailable the cell
containing that time should be shaded)
The fields in the database as it currently stands are:
tblBookedRooms
--------------
strRoomCode
strMeetingTitle
dtmDateOut
dtmTimeOut
dtmTimeIn
I'm at a loss as to how to extract the correct time and link it to a cell in
the table of times (!). Further, How might I address the 15 minute increment
problem, say for example if someone books a room from 2pm to 3pm how might I
highlight 2pm, 2:15,2:30 and 2:45??
I hope this makes sense, I've had a lot of coffee.
Any help would be great, TIA.
Clo
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
|
|
|
View Cart
