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:

ListWords passing multi values in one form field (2000) Check boxes (1997) access denied problem (1997) webstar (ot) (2001) Great product and great job ! (1997) Ampersand (1997) New index for docs (1997) New Guestbook Source (1997) Width & Height (1998) WebCat2b15MacPlugin - [protect] (1997) WebDNS and RSS (2003) Running _every_ page through WebCat ? (1997) Help with Shipping Costs (1997) Format all of a sudden doesn't work (1997) Bug? (1997) Web Catalog vs. ICAT (1997) RE: Signal Raised (1997) FEW QUESTIONS (1997) Limitations on fields? Server is crashing (1997) Great product and great job ! (1997)