Re: available times?

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52865
interpreted = N
texte = Ooops, had an [text] tag in there, remove those. G. Gary Krockover wrote: > Ron, > > How about this, where the loop start/end are inputs from the times > requested: > > [math show=f]ticker=0[/math] > [search db=beatings.db&neskudatarq=[blank]] > [founditems] > [Loop start=0530&end=1400] > [showif [index]=[s_time]][text][math > show=f]ticker=ticker+1[/math][/showif] [showif > [index]=[e_time]][text][math show=f]ticker=ticker+1[/math][/showif] > [/Loop] [/founditems] > [/search] >
> [showif [ticker]=0]Appt. scheduled![/showif] > [showif [ticker]!0]Sorry, time not available[/showif] > > [!]beatings.db[/!] > [!] sku s_time e_time [/!] > [!] 1 700 800 [/!] > [!] 2 1200 1300 [/!] > > G. > > 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)
Ooops, had an [text] tag in there, remove those. G. Gary Krockover wrote: > Ron, > > How about this, where the loop start/end are inputs from the times > requested: > > [math show=f]ticker=0[/math] > [search db=beatings.db&neskudatarq=[blank]] > [founditems] > [Loop start=0530&end=1400] > [showif [index]=[s_time]][text][math > show=f]ticker=ticker+1[/math][/showif] [showif > [index]=[e_time]][text][math show=f]ticker=ticker+1[/math][/showif] > [/Loop] [/founditems] > [/search] >
> [showif [ticker]=0]Appt. scheduled![/showif] > [showif [ticker]!0]Sorry, time not available[/showif] > > [!]beatings.db[/!] > [!] sku s_time e_time [/!] > [!] 1 700 800 [/!] > [!] 2 1200 1300 [/!] > > G. > > 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:

NewCart+Search with one click ? (1997) Undeliverable Mail (1997) Navigator 4.01 (1997) Re2: frames & carts (1997) searchable list archive (1997) Databases inside [SHOWIF] (1998) DON'T use old cart file! (1997) PROBLEMS WITH PROTECT TAG (2004) New Plug-in and Type 11 errors (1997) Appendfile memory usage (redux) (2003) Searchable WebCat (etc.) Docs ? (1997) Who is doing sign-ups-got it (1998) Modifying order output (1997) [WebDNA] Is a '.webdna' suffix better? (2008) Lookup Notfound (1998) WCS Newbie question (1997) Doesn't change (WebCat 4.0) (2000) File Upload (1997) Greeting Card System (2000) Testing, Sorry (1998)