Re: available times?
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52866
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Tim Robinson
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:
PIXO support (1997)
Creating main- and sub-category search (1997)
Email Problem (1997)
Re:E-mailer application times out (1998)
Secure server question (1997)
re-sorting founditems (2002)
Cannot calculate prices (1997)
Email Formatting (2001)
SiteEdit NewFile.html ? (1997)
Include a big block of text (1997)
using showpage and showcart commands (1996)
$Quit, $CloseDatabase corrections (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
New command suggestion (1997)
SSL (1998)
Banners (1997)
[SearchString] usage (1997)
Signal Raised Error (1997)
Summary search -- speed (1997)
no template caching (1997)