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 that needs to compare submited times to see if they are available. Time is submit as: s_hour - requested start hour s_minutes - requested start minute e_hour - requested end hour e_minutes - requested end minute For comparison sake we use military time so hours are 01-23 We have two fields in the DB for the entered meetings: s_time - start time e_time - end time we put the times together when submitted: [s_hour][s_minute] = 0705 (minutes are in 5 minute intervals) so what we need is this: Scheduled meetings S_TIME - E_TIME 0700 - 0800 1200 - 1300 Requested times 0730 - 0830 - fail 1230 - 1330 - fail 0530 - 1400 - fail - the hard one 0900 - 1100 - pass 1 - 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:

    
  1. Re: available times? ( "WebDna @" 2003)
  2. Re: available times? ( Tim Robinson 2003)
  3. Re: available times? ( Tim Robinson 2003)
  4. Re: available times? ( "Gary Krockover" 2003)
  5. Re: available times? ( "Gary Krockover" 2003)
  6. Re: available times? ( Donovan 2003)
  7. Re: available times? ( "WebDna @" 2003)
  8. Re: available times? ( "WebDna @" 2003)
  9. Re: available times? ( Donovan 2003)
  10. Re: available times? ( "WebDna @" 2003)
  11. Re: available times? ( "Gary Krockover" 2003)
  12. Re: available times? ( "WebDna @" 2003)
  13. Re: available times? ( Donovan 2003)
  14. Re: available times? ( "WebDna @" 2003)
  15. Re: available times? ( Donovan 2003)
  16. Re: available times? ( "WebDna @" 2003)
  17. Re: available times? ( Tim Robinson 2003)
  18. available times? ( "WebDna @" 2003)
Ok everyone I am in need of assistance. I have a meeting scheduler that needs to compare submited times to see if they are available. Time is submit as: s_hour - requested start hour s_minutes - requested start minute e_hour - requested end hour e_minutes - requested end minute For comparison sake we use military time so hours are 01-23 We have two fields in the DB for the entered meetings: s_time - start time e_time - end time we put the times together when submitted: [s_hour][s_minute] = 0705 (minutes are in 5 minute intervals) so what we need is this: Scheduled meetings S_TIME - E_TIME 0700 - 0800 1200 - 1300 Requested times 0730 - 0830 - fail 1230 - 1330 - fail 0530 - 1400 - fail - the hard one 0900 - 1100 - pass 1 - 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:

WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Re:2nd WebCatalog2 Feature Request (1996) Case sensitivity and [showif] (1999) Problems with [Search] param - Mac Plugin b15 (1997) Country & Ship-to address & other fields ? (1997) PCS Frames (1997) WebCat2b15MacPlugin - [protect] (1997) includes and cart numbers (1997) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) Question on the sandbox (2003) OT: Dynamic table equivalent (2008) IE, Layers, and Select (2002) Searching multiple fields (1997) WebCat2 several catalogs? (1997) Listserver problem (1997) Math problems (1998) [SearchString] problem with [search] context (1997) [TaxableTotal] - not working with AOL and IE (1997) Re:2nd WebCatalog2 Feature Request (1996) WebDNA and Amazon S3 (2006)