Re: available times?
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52867
interpreted = N
texte = PART 2. And would also need a [numFound] (also 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]] [text]total_found=[numfound][/text] [founditems] [if ("[S_TIME]"="[e_hour][e_minute]")[!] [/!]|("[E_TIME]"="[s_hour][s_minute]")[!] [/!]|("[total_found]"="0")] [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:
PART 2. And would also need a [numFound] (also 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]] [text]total_found=[numfound][/text] [founditems] [if ("[S_TIME]"="[e_hour][e_minute]")[!] [/!]|("[E_TIME]"="[s_hour][s_minute]")[!] [/!]|("[total_found]"="0")] [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:
Slightly OT: [sendmail] help (2003)
add to cart within a page? (1997)
searching with groups (1997)
Field Totals (2004)
[SearchString] usage (1997)
no global [username] or [password] displayed ... (1997)
[WebDNA] multi hyperlinks in text paragraphs (2014)
Requiring that certain fields be completed (1997)
WCS Newbie question (1997)
WebCat2b12 - nesting [tags] (1997)
In Digest Dijon (2000)
Just made store and move file from webcatalog......... (2000)
Problem (1997)
hideif glitch (2003)
Error handling for accountNum (1997)
Mozilla/4. and Browser Info.txt (1997)
close to search (2001)
browser info.txt and SSL (1997)
more info on [setlineitems] (1997)
ANN: Strategic Partnership with BuyStream Announced. (2000)