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:
[WebDNA] Help with ReplaceFoundItems (2009)
RE: [WebDNA] WebDNA 7 (2011)
text size limitation (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Adding Message to Order (1997)
HELP WITH DATES (1997)
WebCatalog Upgrade Pricing? (1997)
[WriteFile] problems (1997)
Protecting webdelivery (1997)
webcat- multiple selection in input field (1997)
I'm new be kind (1997)
numfound=0 for a search after going into the SSL (2003)
matching shipto and others (1998)
WebMerchant? (1998)
Secure Server not remembering discounts (1998)
shownext problems (1998)
Almost a there but..bye bye NetCloak (1997)
exclusive db lock with webcat-3 ? (2000)
Country & Ship-to address & other fields ? (1997)
comma-delimited email (1998)