Date Search
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55346
interpreted = N
texte = 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? :) -- Jesse Williams-Proudman Blue Box Development :: Custom Web Solutions +1.206.778.8777 :: jesse@blueboxdev.com *Happy Holidays* ------------------------------------------------------------- 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:
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? :) -- Jesse Williams-Proudman Blue Box Development :: Custom Web Solutions +1.206.778.8777 :: jesse@blueboxdev.com *Happy Holidays* ------------------------------------------------------------- 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/
Jesse Proudman
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:
Unusual characters in the db ... (2002)
ReplaceFoundItems (2006)
unable to launch acgi in WebCat (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
test (2001)
pop up menu's (1998)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
RE: Adding a product from another site (1997)
[Sum] function? (1997)
Math Context (1998)
Items XX to XX shown (1997)
Math, Multiple Equasions and Show/Hide (1998)
WebDNA error. (2006)
UPS charges (2000)
using bw in a search on a numeric field (2000)
Resolving variables into field names (1998)
Writefile doesn't work, which permissions to use? (2005)
SiteGuard Admin Feature ? (1997)
[WebDNA] Processor usage off the charts (2008)
WebCatalog2 Feature Feedback (1996)