Re: available times?

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52853
interpreted = N
texte = Perhaps something as simple as: [showif [s_time]~07]fail[/showif] [showif [s_time]~12]fail[/showif] However you have problems if s_time is anything other than on the hour (00). You'd also have to make exceptions if the scheduled times are longer than an hour. Might be something to play with though. Ok, back to the game. :) GK WebDna @ wrote: > 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/ ------------------------------------------------------------- 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)
Perhaps something as simple as: [showif [s_time]~07]fail[/showif] [showif [s_time]~12]fail[/showif] However you have problems if s_time is anything other than on the hour (00). You'd also have to make exceptions if the scheduled times are longer than an hour. Might be something to play with though. Ok, back to the game. :) GK WebDna @ wrote: > 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/ ------------------------------------------------------------- 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/ "Gary Krockover"

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:

Practice runs ? (1997) Bad creator codes which cause access denied error message (1997) killer-format in cart (1998) Initiating NewCart (1997) You sent this to me by mistake. (1998) RAM variables (1997) rotating thumbnails (1997) WebCatalog Work (2001) Math with Time (1997) shipping formula (2000) OT: Unknown Webstar Error ruining presentation?! (2001) [OT] : Chat Room on OSX (2003) is your webDNA site 'froogle' ready ??? (2003) Attn: Bug in GeneralStore example b15 (1997) Math, Multiple Equasions and Show/Hide (1998) WebCat & WebTen (1997) Carts & Refering URLs (1997) Trouble with formula.db (1997) Checking for blank form fields (sort of...) (1998) Where's Cart Created ? (1997)