Re: available times?

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52868
interpreted = N
texte = This is how I have I got it working. Anyone want to clean up this code please feel free. I am happy to see it. submited from form: s_hours = hour of starting s_minute = minute of starting e_hour = hour of ending e_minute = minute of ending P_ID = Personnel Id (we create thePID from the submitted P_ID) hours are in military (0100 - 2355) ------------- [search db=schedules.db&rnS_TIMEdata=[s_hour][s_minute] [e_hour][e_minute]&S_TIMEtype=num] [founditems] [showif [p_ID]=[thePID]] [showif [s_hour][s_minute]=[e_time]] Warning[/showif] [/showif] [showif [s_hour][s_minute]![e_time]] error w/ start time - [S_TIME] - [E_TIME]
[/showif] [/founditems] [/search] We do the same for the ending. So there it is. ----- Original Message ----- From: "Tim Robinson" To: "WebDNA Talk" Sent: Saturday, September 13, 2003 2:37 PM Subject: Re: available times? > How about something like (untested): > > [Search db=xx.db&rnS_TIMEdata=[s_hour][s_minute] [e_hour][e_minute][!] > [/!]&rnE_TIMEdata=[s_hour][s_minute] [e_hour][e_minute]] > [founditems] > [if ("[S_TIME]"="[e_hour][e_minute]")|("[E_TIME]"="[s_hour][s_minute]")] > [then]OK[/then] > [else]Failed[/else] > [/if] > [/founditems] > [/search] > > Tim > > > From: "WebDna @" > > Reply-To: (WebDNA Talk) > > Date: Sat, 13 Sep 2003 10:35:33 -0700 > > To: (WebDNA Talk) > > Subject: Re: available times? > > > > :: cackles wildly as his eyes threaten to bug forth from his skull! :: > > > > The Range worked -- sortof. > > > > It does what we wanted with catching overlapping meetings. > > > > Thanks Tim as you did suggest this and I had rule dit out thinking I knew > > how range worked. I apologize to all that made other suggestions because of > > my assurance that it did not work. > > > > Now with all my humbling over with we have an issue with the Range search. > > > > We have a 7:00 - 8:00 and we want an 8:00 to 9:00 I get an error. As it sees > > the 8:00 as part fo the range? > > > > Ideas? > > > > > > > > ----- Original Message ----- > > From: "WebDna @" > > To: "WebDNA Talk" > > Sent: Saturday, September 13, 2003 10:14 AM > > Subject: Re: available times? > > > > > >> I think I am being an idiot. I do believe the Range Search will do what we > >> want. > >> > >> I will post a follow up in a few minutes. > >> > >> > >> ----- Original Message ----- > >> From: "WebDna @" > >> To: "WebDNA Talk" > >> Sent: Saturday, September 13, 2003 9:56 AM > >> Subject: Re: available times? > >> > >> > >>> Yeah I thought about using epoch, but it still has the same exact > > issues. > >>> > >>> I cannot figure out the comparisons for the searches or showifs or > >> whatever. > >>> > >>> If the time is in the middle of a scheduled meeting: request_start(or > >>> end)_time=1300 (1pm o'clock) > >>> > >>> Scheduled meeting 1200 - 1400 > >>> > >>> A range search would find this. But what of when the requested start > > time > >> is > >>> 1100 and the requested end is 1500? The times are not in the scheduled > > so > >> it > >>> will not see it. > >>> > >>> This does not matter if I am searching 1-23 jsut as numbers or epoch as > >>> 63230579052. > >>> > >>> scheduled: 5-7 > >>> want a 4 to 8 breaks. > >>> > >>> Scheduled: 63230579052 - 63230579102 > >>> want a 63230579050 - 63230579103 breaks > >>> > >>> And then once I get this comparison to work I have to make it part of > > the > >>> larger check some how. I am afraid I am making this too complex, but > > then > >>> again I have that habit. > >>> > >>> Please do not take this as me being rude. Email loses alot of tone. I am > >>> appreciative of any assistance on this. > >>> > >>> > >>> > >>> ----- Original Message ----- > >>> From: "Donovan" > >>> To: "WebDNA Talk" > >>> Sent: Saturday, September 13, 2003 9:37 AM > >>> Subject: Re: available times? > >>> > >>> > >>>> WebDna @ wrote: > >>>>> It is a custom build and new, so modifications are welcomed. > >>>> > >>>> Ron I would do a date and time as seconds since epoch. you will > >>>> never have problems with this (that I know of). > >>>> > >>>> Tell the user to select a date and time of the meating. > >>>> > >>>> convert it to one number > >>>> > >>>> REF: http://www.euca.us/admin/tests/sectodays.html > >>>> > >>>> And then compare by a num range search. > >>>> If the num (date/time in sec) requested is between a meeting that is > >>>> already scheduled then the user will have to pick another time. > >>>> > >>>> You will have precision down to seconds. > >>>> Donovan > >>>> > >>>> > >>>> -- > >>>> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > >>>> DONOVAN D. BROOKE > >>>> Eucalyptus Design > >>>> Developer / Consultant > >>>> <-Web Development (specializing in eCommerce), -> > >>>> <-Graphic Design, and Pre-Press Consultation -> > >>>> > >>>> ADDRESS:> Donovan Brooke > >>>> DBA Eucalyptus Design > >>>> P.O. Box 260153 > >>>> Madison, WI 53726-0153 > >>>> > >>>> PH:> 1.608.592.3567 > >>>> email:> dbrooke@euca.us > >>>> Web:> http://www.euca.us > >>>> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > >>>> > >>>> > >>>> ------------------------------------------------------------- > >>>> 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/ > >> > >> > >> ------------------------------------------------------------- > >> 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/ > > > ------------------------------------------------------------- > 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)
This is how I have I got it working. Anyone want to clean up this code please feel free. I am happy to see it. submited from form: s_hours = hour of starting s_minute = minute of starting e_hour = hour of ending e_minute = minute of ending P_ID = Personnel Id (we create thePID from the submitted P_ID) hours are in military (0100 - 2355) ------------- [search db=schedules.db&rnS_TIMEdata=[s_hour][s_minute] [e_hour][e_minute]&S_TIMEtype=num] [founditems] [showif [p_ID]=[thePID]] [showif [s_hour][s_minute]=[e_time]] Warning[/showif] [/showif] [showif [s_hour][s_minute]![e_time]] error w/ start time - [S_TIME] - [E_TIME]
[/showif] [/founditems] [/search] We do the same for the ending. So there it is. ----- Original Message ----- From: "Tim Robinson" To: "WebDNA Talk" Sent: Saturday, September 13, 2003 2:37 PM Subject: Re: available times? > How about something like (untested): > > [Search db=xx.db&rnS_TIMEdata=[s_hour][s_minute] [e_hour][e_minute][!] > [/!]&rnE_TIMEdata=[s_hour][s_minute] [e_hour][e_minute]] > [founditems] > [if ("[S_TIME]"="[e_hour][e_minute]")|("[E_TIME]"="[s_hour][s_minute]")] > [then]OK[/then] > [else]Failed[/else] > [/if] > [/founditems] > [/search] > > Tim > > > From: "WebDna @" > > Reply-To: (WebDNA Talk) > > Date: Sat, 13 Sep 2003 10:35:33 -0700 > > To: (WebDNA Talk) > > Subject: Re: available times? > > > > :: cackles wildly as his eyes threaten to bug forth from his skull! :: > > > > The Range worked -- sortof. > > > > It does what we wanted with catching overlapping meetings. > > > > Thanks Tim as you did suggest this and I had rule dit out thinking I knew > > how range worked. I apologize to all that made other suggestions because of > > my assurance that it did not work. > > > > Now with all my humbling over with we have an issue with the Range search. > > > > We have a 7:00 - 8:00 and we want an 8:00 to 9:00 I get an error. As it sees > > the 8:00 as part fo the range? > > > > Ideas? > > > > > > > > ----- Original Message ----- > > From: "WebDna @" > > To: "WebDNA Talk" > > Sent: Saturday, September 13, 2003 10:14 AM > > Subject: Re: available times? > > > > > >> I think I am being an idiot. I do believe the Range Search will do what we > >> want. > >> > >> I will post a follow up in a few minutes. > >> > >> > >> ----- Original Message ----- > >> From: "WebDna @" > >> To: "WebDNA Talk" > >> Sent: Saturday, September 13, 2003 9:56 AM > >> Subject: Re: available times? > >> > >> > >>> Yeah I thought about using epoch, but it still has the same exact > > issues. > >>> > >>> I cannot figure out the comparisons for the searches or showifs or > >> whatever. > >>> > >>> If the time is in the middle of a scheduled meeting: request_start(or > >>> end)_time=1300 (1pm o'clock) > >>> > >>> Scheduled meeting 1200 - 1400 > >>> > >>> A range search would find this. But what of when the requested start > > time > >> is > >>> 1100 and the requested end is 1500? The times are not in the scheduled > > so > >> it > >>> will not see it. > >>> > >>> This does not matter if I am searching 1-23 jsut as numbers or epoch as > >>> 63230579052. > >>> > >>> scheduled: 5-7 > >>> want a 4 to 8 breaks. > >>> > >>> Scheduled: 63230579052 - 63230579102 > >>> want a 63230579050 - 63230579103 breaks > >>> > >>> And then once I get this comparison to work I have to make it part of > > the > >>> larger check some how. I am afraid I am making this too complex, but > > then > >>> again I have that habit. > >>> > >>> Please do not take this as me being rude. Email loses alot of tone. I am > >>> appreciative of any assistance on this. > >>> > >>> > >>> > >>> ----- Original Message ----- > >>> From: "Donovan" > >>> To: "WebDNA Talk" > >>> Sent: Saturday, September 13, 2003 9:37 AM > >>> Subject: Re: available times? > >>> > >>> > >>>> WebDna @ wrote: > >>>>> It is a custom build and new, so modifications are welcomed. > >>>> > >>>> Ron I would do a date and time as seconds since epoch. you will > >>>> never have problems with this (that I know of). > >>>> > >>>> Tell the user to select a date and time of the meating. > >>>> > >>>> convert it to one number > >>>> > >>>> REF: http://www.euca.us/admin/tests/sectodays.html > >>>> > >>>> And then compare by a num range search. > >>>> If the num (date/time in sec) requested is between a meeting that is > >>>> already scheduled then the user will have to pick another time. > >>>> > >>>> You will have precision down to seconds. > >>>> Donovan > >>>> > >>>> > >>>> -- > >>>> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > >>>> DONOVAN D. BROOKE > >>>> Eucalyptus Design > >>>> Developer / Consultant > >>>> <-Web Development (specializing in eCommerce), -> > >>>> <-Graphic Design, and Pre-Press Consultation -> > >>>> > >>>> ADDRESS:> Donovan Brooke > >>>> DBA Eucalyptus Design > >>>> P.O. Box 260153 > >>>> Madison, WI 53726-0153 > >>>> > >>>> PH:> 1.608.592.3567 > >>>> email:> dbrooke@euca.us > >>>> Web:> http://www.euca.us > >>>> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > >>>> > >>>> > >>>> ------------------------------------------------------------- > >>>> 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/ > >> > >> > >> ------------------------------------------------------------- > >> 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/ > > > ------------------------------------------------------------- > 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/ "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:

Multiple Users.db Possible? (1997) Web Cat not returning html? (2000) Freeze (2003) Using EIMS instead of Emailer (1998) Line items in table cells (1997) 4.0x on production server (2000) Correlating the record found with the fieldname (2000) WC2b12: Yes, Formulas.db is for real (1997) listfiles-looking for slick solution (1997) WriteFile and returns... (2000) Formatting a .txt file (1998) WebCat2 - Getting to the browser's username/password data (1997) Fwd: Problems with Webcatalog Plug-in (1997) auto-stripping of spaces (1997) [MATH SHOW=F]. show=f does what? (1999) Showif, Hideif reverse logic ? (1997) Cart Number Propagation (1997) carriage returns in data (1997) [LOOKUP] (1997) PCS Frames (1997)