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:
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)