Re: Date Search

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55355
interpreted = N
texte = Jesse, don't mean to use your post as a podium but this is just another case of "it would be nice to have [date secs_to_date],[time secs_to_time],[secs_since_epoch]. I currently do this using someones code, but have to go through some hoops. See my cryptic test page here for more info: http://www.euca.us/admin/tests/sectodays.html When evaluating seconds since epoch, important time differences are easy. [!]set date and time in seconds (Tom Dukes code I believe)[/!] [text]timestamp=[math]((([math]{[date]}[/math])-1)*86400)+([math]{[time]}[/math])[/math][/text] [!] set evaluation time of 30 minutes ago[/!] [text]evaltime=[math][timestamp]-(30[!]min[/!]*60)[/math] [!] look it up [/!] [search db=specs.db&rnDNA_VISIT_DTdatarq=[evaltime] [timestamp]&DNA_VISIT_DTtype=num] This finds your data to the second! Sorry that I can't answer your question. Donovan Jesse Proudman wrote: > I've got a database with the dates and times of accesses on a site. I > want to do a search to show all the access on the site in the last 30 > minutes, regardless of the time of day. The following search breaks > between 12:00 am and 12:30 am.... Ideas? > > [search db=^DNAforum/DNAuserspecs.db&eqKEYdatarq=[url][dnakey][/url][if > [getchars > start=1&end=2][time][/getchars]=00][then]&rnDNAvisitdtdatarq=[/ > then][else]&eqDNAvisitdtdatarq=[include > file=^DNAforum/DNAvitals/dateoffset.inc][/else][/ > if]&rnDNAvisittmdatarq=[include > file=^DNAforum/DNAvitals/timeoffset.inc] > [time]&DNAvisitdttype=date&DNAvisittmtype=time&DNAvisitdtsort=1][foundit > ems][DNAuid],[/founditems][/search] > > The time offset file simply figures out what the time would be minus 30 > minutes so at 12:20 that part of the search looks like: > > 23:50:00 00:20:00 > > My guess is the search is crapping out because WebDNA doesn't know how > to handle the second integer being smaller than the first. The search > makes logical sense in my head but I guess the parser thinks differently. > > Ideas? :) -- =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 <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: date search not working when type=date specified ( Charles Kline 2007)
  2. Re: date search not working when type=date specified ( Charles Kline 2007)
  3. Re: date search not working when type=date specified ( Charles Kline 2007)
  4. Re: date search not working when type=date specified ( Terry Wilson 2007)
  5. Re: date search not working when type=date specified ( Chris 2007)
  6. Re: date search not working when type=date specified ( thierry 2007)
  7. Re: date search not working when type=date specified ( Stuart Tremain 2007)
  8. Re: date search not working when type=date specified ( Gary Krockover 2007)
  9. Re: date search not working when type=date specified ( Donovan Brooke 2007)
  10. Re: date search not working when type=date specified ( Stuart Tremain 2007)
  11. date search not working when type=date specified ( Charles Kline 2007)
  12. Re: Date Search ( "Nitai @ ComputerOil" 2004)
  13. Re: Date Search ( "Dan Strong" 2004)
  14. Re: Date Search ( Jesse Proudman 2004)
  15. Re: Date Search ( "Dan Strong" 2004)
  16. Re: Date Search ( Jesse Proudman 2004)
  17. Re: Date Search ( Donovan Brooke 2004)
  18. Re: Date Search ( Kenneth Grome 2004)
  19. Date Search ( Jesse Proudman 2004)
  20. Re: summarizing date search by month... (Joseph D'Andrea 2000)
  21. summarizing date search by month... (John 2000)
  22. re: date search problem (Allen Booth 1999)
  23. re: date search problem (Allen Booth 1999)
  24. Re: Date search bug? (Kenneth Grome 1998)
  25. Re: Date search bug (Kenneth Grome 1998)
  26. Re: Date search bug (Gil Poulsen 1998)
  27. Re: Date search bug (Kenneth Grome 1998)
  28. Re: Date search bug (Gil Poulsen 1998)
  29. Re: Date search bug (John Hill 1998)
  30. Re: Date search bug (Gil Poulsen 1998)
  31. Re: Date search bug (nelson@fwgi.com 1998)
  32. Re: Date search bug (Kenneth Grome 1997)
  33. Re: Date search and sendmail (Grant Hulbert 1997)
  34. Re: Date search and sendmail (Kenneth Grome 1997)
  35. Re: Date search - yes or no (John Hill 1997)
  36. Re: Date search - yes or no (Kenneth Grome 1997)
  37. Re: Date search - yes or no (grichter@panavise.com (Gary Richter) 1997)
  38. Re: Date search - yes or no (Kenneth Grome 1997)
Jesse, don't mean to use your post as a podium but this is just another case of "it would be nice to have [date secs_to_date],[time secs_to_time],[secs_since_epoch]. I currently do this using someones code, but have to go through some hoops. See my cryptic test page here for more info: http://www.euca.us/admin/tests/sectodays.html When evaluating seconds since epoch, important time differences are easy. [!]set date and time in seconds (Tom Dukes code I believe)[/!] [text]timestamp=[math]((([math]{[date]}[/math])-1)*86400)+([math]{[time]}[/math])[/math][/text] [!] set evaluation time of 30 minutes ago[/!] [text]evaltime=[math][timestamp]-(30[!]min[/!]*60)[/math] [!] look it up [/!] [search db=specs.db&rnDNA_VISIT_DTdatarq=[evaltime] [timestamp]&DNA_VISIT_DTtype=num] This finds your data to the second! Sorry that I can't answer your question. Donovan Jesse Proudman wrote: > I've got a database with the dates and times of accesses on a site. I > want to do a search to show all the access on the site in the last 30 > minutes, regardless of the time of day. The following search breaks > between 12:00 am and 12:30 am.... Ideas? > > [search db=^DNAforum/DNAuserspecs.db&eqKEYdatarq=[url][dnakey][/url][if > [getchars > start=1&end=2][time][/getchars]=00][then]&rnDNAvisitdtdatarq=[/ > then][else]&eqDNAvisitdtdatarq=[include > file=^DNAforum/DNAvitals/dateoffset.inc][/else][/ > if]&rnDNAvisittmdatarq=[include > file=^DNAforum/DNAvitals/timeoffset.inc] > [time]&DNAvisitdttype=date&DNAvisittmtype=time&DNAvisitdtsort=1][foundit > ems][DNAuid],[/founditems][/search] > > The time offset file simply figures out what the time would be minus 30 > minutes so at 12:20 that part of the search looks like: > > 23:50:00 00:20:00 > > My guess is the search is crapping out because WebDNA doesn't know how > to handle the second integer being smaller than the first. The search > makes logical sense in my head but I guess the parser thinks differently. > > Ideas? :) -- =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 <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 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/ Donovan Brooke

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:

Hey .. so when are you guys (2004) [OT] HTML Table Cell Problem (2003) re: [addlineitem] working almost (1997) Remove from list server (1997) [OT] Airport Problem (2003) can you reassign loop index? (1998) Old BugaBoos (2000) formatting search results (1999) problems with 2 tags shakur (1997) ICVerify problems (2001) Help needed: older WebCat app breaks under 4.0.1 (2000) A link and two command (1998) WebCat for Unix?? (1997) [WebDNA] Mac Question (2018) Upgrading old WebCat Database Files (1997) WebCommerce: Folder organization ? (1997) Major bug report on rootbeer (1997) Database Helper Update (1998) sort (2000) [SHOWIF AND/OR] (1997)