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 codeplease feel free. I am happy to see it.submited from form:s_hours = hour of startings_minute = minute of startinge_hour = hour of endinge_minute = minute of endingP_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 PMSubject: 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 Iknew> > how range worked. I apologize to all that made other suggestions becauseof> > my assurance that it did not work.> >> > Now with all my humbling over with we have an issue with the Rangesearch.> >> > We have a 7:00 - 8:00 and we want an 8:00 to 9:00 I get an error. As itsees> > 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 whatwe> >> 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 epochas> >>> 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. Iam> >>> 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:

Re: available times? ( "WebDna @" 2003)
Re: available times? ( Tim Robinson 2003)
Re: available times? ( Tim Robinson 2003)
Re: available times? ( "Gary Krockover" 2003)
Re: available times? ( "Gary Krockover" 2003)
Re: available times? ( Donovan 2003)
Re: available times? ( "WebDna @" 2003)
Re: available times? ( "WebDna @" 2003)
Re: available times? ( Donovan 2003)
Re: available times? ( "WebDna @" 2003)
Re: available times? ( "Gary Krockover" 2003)
Re: available times? ( "WebDna @" 2003)
Re: available times? ( Donovan 2003)
Re: available times? ( "WebDna @" 2003)
Re: available times? ( Donovan 2003)
Re: available times? ( "WebDna @" 2003)
Re: available times? ( Tim Robinson 2003)
available times? ( "WebDna @" 2003)

This is how I have I got it working. Anyone want to clean up this codeplease feel free. I am happy to see it.submited from form:s_hours = hour of startings_minute = minute of startinge_hour = hour of endinge_minute = minute of endingP_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 PMSubject: 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 Iknew> > how range worked. I apologize to all that made other suggestions becauseof> > my assurance that it did not work.> >> > Now with all my humbling over with we have an issue with the Rangesearch.> >> > We have a 7:00 - 8:00 and we want an 8:00 to 9:00 I get an error. As itsees> > 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 whatwe> >> 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 epochas> >>> 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. Iam> >>> 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!

Re: available times?

2003

Top Articles:

Related Readings: