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:
WebCat hosting sites? (1998)
I can't set the variable (2005)
RE: Purchased cart being overwritten (1997)
move files (2000)
page redirect in webDNA (1997)
RAM variables (1997)
WC2b15 File Corruption (1997)
Credit Card Gateways (2005)
SFTP [scp solution] (2004)
Dummy Credit Card Number for debug? (1997)
line breaks in sendmail (1998)
TCP Connect code for SMTP transaction (2004)
Banners (1997)
service stop and restart (1997)
upgrading to windows 2000 (2001)
Error 551 (2000)
totals (1997)
Finalizing Orders (2000)
orderfile and setlineitems (1998)
Download Question (1997)