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:

WebCat editing, SiteGuard & SiteEdit (1997) Shipcost lookup? (1997) WebCat preferences caching problem (2000) emailer don't work (1998) WebCat virtual postcard is done! Thanks for the help! (1998) 2.0Beta Command Ref (can't find this instruction) (1997) Confirming a bug/oddity (2003) simple [convertChars] Q (2000) New Command prefs ... (1997) Don't tick me off :) [elaspedtime] (1997) OT - New Ti Books (2002) Emailer choke (1997) Groups doesn't work (1997) multi-paragraph fields (1997) upgrading (1997) For those of you not on the WebCatalog Beta... (1997) Two submit buttons ? (1997) Error Lob.db records error message not name (1997) Help formatting search results w/ table (1997) Errata: WCS Newbie question (1997)