Re: available times?
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52857
interpreted = N
texte = :: 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 knewhow range worked. I apologize to all that made other suggestions because ofmy 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 seesthe 8:00 as part fo the range?Ideas?----- Original Message ----- From: "WebDna @"
To: "WebDNA Talk" Sent: Saturday, September 13, 2003 10:14 AMSubject: 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 exactissues.> >> > 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 starttime> is> > 1100 and the requested end is 1500? The times are not in the scheduledso> 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 ofthe> > larger check some how. I am afraid I am making this too complex, butthen> > 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/
Associated Messages, from the most recent to the oldest:
:: 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 knewhow range worked. I apologize to all that made other suggestions because ofmy 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 seesthe 8:00 as part fo the range?Ideas?----- Original Message ----- From: "WebDna @" To: "WebDNA Talk" Sent: Saturday, September 13, 2003 10:14 AMSubject: 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 exactissues.> >> > 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 starttime> is> > 1100 and the requested end is 1500? The times are not in the scheduledso> 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 ofthe> > larger check some how. I am afraid I am making this too complex, butthen> > 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/
"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:
Re:listfiles-looking for slick solution (1997)
Limitations on fields? Server is crashing (1997)
sBox (2002)
Credit Card Checking?? (1998)
Problem with updating 2.1b7 -> 2.1.1 (1998)
[WebDNA] Error 500 with SUMM=T (2017)
Re:2nd WebCatalog2 Feature Request (1996)
[BULK] [WebDNA] Problem with bcc email (2017)
[BULK] [WebDNA] [BULK] 7.x and 6.x on same server (2012)
Sorting (1998)
Append..... doesn't (2000)
MacOS alias identification? (1998)
Re[2]: Search Engines (2000)
[WebDNA] [thisurl] (2010)
WebCat2 Append problem (B14Macacgi) (1997)
frames & carts (1997)
Format question WC Mac f3 (1997)
page redirect in webDNA (1997)
File not found error message (1998)
question: back button prevention (1997)