Re: Date Search
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55358
interpreted = N
texte = On Jan 9, 2004, at 1:13 AM, Kenneth Grome 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? > > > Can't tell anything from your code because all the important stuff is > in the include files, but it's clear that it's breaking because the > day has changed, which means your code is apparently not compensating > as it should.= Like I said, the include files are pretty basic, but here ya go: newuserhours is a text variable set in a header. It's current value is: 00:30:00 timeoffset.inc: [math time&show=f]GMT={[date %X]}-{[newuserhours]}[/math][!] [/!][math time&show=f]NOW={[date %X]}[/math][!] [/!][if "[offset]"="[raw][offset][/raw]"][!] [/!][then][!] [/!][math show=f]offsettime=0[/math][/then][!] [/!][else][!] [/!][math show=f]offsettime=[offset]*60[/math][/else][!] [/!][/if][!] [/!][math time&show=f]GMTdate=[GMT]+[offsettime][/math][!] [/!][Format Seconds_To_Time][GMTdate][/Format] -- 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:
On Jan 9, 2004, at 1:13 AM, Kenneth Grome 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? > > > Can't tell anything from your code because all the important stuff is > in the include files, but it's clear that it's breaking because the > day has changed, which means your code is apparently not compensating > as it should.= Like I said, the include files are pretty basic, but here ya go: newuserhours is a text variable set in a header. It's current value is: 00:30:00 timeoffset.inc: [math time&show=f]GMT={[date %X]}-{[newuserhours]}[/math][!] [/!][math time&show=f]NOW={[date %X]}[/math][!] [/!][if "[offset]"="[raw][offset][/raw]"][!] [/!][then][!] [/!][math show=f]offsettime=0[/math][/then][!] [/!][else][!] [/!][math show=f]offsettime=[offset]*60[/math][/else][!] [/!][/if][!] [/!][math time&show=f]GMTdate=[GMT]+[offsettime][/math][!] [/!][Format Seconds_To_Time][GMTdate][/Format] -- 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:
Smith Micro - no competition (2000)
emailer (1997)
WebCatalog can't find database (1997)
The List is Changing (1997)
Looping control (1997)
Auto Date (2001)
Physical Proximity searches (2000)
problems with WebCat-Plugin ()
Database Not Found Problem (2004)
hmmm (2006)
2nd WebCatalog2 Feature Request (1996)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
using showpage and showcart commands (1996)
Editing the search string (1997)
RE: Webcatalog and CyberSTUD (1998)
[WebDNA] HTTP crashes (2010)
Problems appending to database (1997)
Web Merchant process after credit card clears (1998)
Database Structuring (again) (2003)
WebCat, switching from NT to OSX (2003)