available times?
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52831
interpreted = N
texte = Ok everyone I am in need of assistance. I have a meeting scheduler thatneeds to compare submited times to see if they are available.Time is submit as:s_hour - requested start hours_minutes - requested start minutee_hour - requested end houre_minutes - requested end minuteFor comparison sake we use military time so hours are 01-23We have two fields in the DB for the entered meetings:s_time - start timee_time - end timewe put the times together when submitted:[s_hour][s_minute] = 0705 (minutes are in 5 minute intervals)so what we need is this:Scheduled meetingsS_TIME - E_TIME0700 - 08001200 - 1300Requested times0730 - 0830 - fail1230 - 1330 - fail0530 - 1400 - fail - the hard one0900 - 1100 - pass1 - 3 should fail, but 4 should be accepted. So how do I compare this data?Thanks,-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Ok everyone I am in need of assistance. I have a meeting scheduler thatneeds to compare submited times to see if they are available.Time is submit as:s_hour - requested start hours_minutes - requested start minutee_hour - requested end houre_minutes - requested end minuteFor comparison sake we use military time so hours are 01-23We have two fields in the DB for the entered meetings:s_time - start timee_time - end timewe put the times together when submitted:[s_hour][s_minute] = 0705 (minutes are in 5 minute intervals)so what we need is this:Scheduled meetingsS_TIME - E_TIME0700 - 08001200 - 1300Requested times0730 - 0830 - fail1230 - 1330 - fail0530 - 1400 - fail - the hard one0900 - 1100 - pass1 - 3 should fail, but 4 should be accepted. So how do I compare this data?Thanks,-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"WebDna @"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Webcat/Webmerchant part II (1998)
Email Formatting and Encryption (1998)
Emailer help....! (1997)
WebCat2: Items xx to xx shown, etc. (1997)
SKU lookup (1997)
using WC to create a DB online (2000)
Multiple fields on 1 input (1997)
Server Load Tester (2000)
Nested tags count question (1997)
SiteEdit Pro Update Announcement (1997)
All of a Sudden Type 2 errors (1999)
More Applescript (1997)
[WebDNA] Version 8 (2014)
Loosing Quantity (2000)
Anybody running directory indexer? (1998)
pc (1997)
UPPERCASE (1997)
Bug Report, maybe (1997)
[ot] html question (2000)
What am I missing (1997)