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:

[OT] Bookmarking code (2003) Editing the search string (1997) Location of Webcat site in folder hierarchy (1997) [WebDNA] Search on database (2012) Tags in the header (2000) webcat- multiple selection in input field (1997) Server capacity (2003) Superfilous Characters (1998) [encrypt] blues.... (2000) Tax Rates (1998) SSL and Webstar 3 with Webcatalog (1998) Problems with date math (1997) ampersand in a sendmail body (2007) variables in [addlineitem] (1998) Re:FYI: Error message (1996) Re:Help name our technology! (1997) WebCommerce: Folder organization ? (1997) How about the Pascal approach? (2004) Emailer help....! (1997) Sorting by date (1997)