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:

Newbie questions (1999) SMTP Mail Server (2003) [WebDNA] Search on a database (2012) Cart Numbers (1997) Classified (1999) Virtual Postcards (1998) SiteGuard Admin Feature ? (1997) ANN: Strategic Partnership with BuyStream Announced. (2000) Width & Height (1998) WebCat wont loose it's cookies! (1999) Looking for a Manual (1997) [WebDNA] Base64 (2014) Looking For WebCatalog Migration Assistance (2003) math on date? (1997) [searchString] (1997) Signal Raised Error (1997) Emailer Set Up (1997) [isfile] ? (1997) Setting up shop (1997) Bug or syntax error on my part? (1997)