Re: Date Sorting
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12422
interpreted = N
texte = At 3:47 PM 7/13/97, Grant Hulbert altered the fabric of cyberspace,writing:> >I have been trying to get some date sorting correct, but have had only> >limited luck. I am using:> >> >Announcement.tmpl$search?db=Announce.db&geEventDatedata&EventDatesort=1> >&EventDatetype=date&EventDatesdir=de&max=10>> Two things:>> 1) geEventDatedata needs something after it, like geEventDatedata=7/9/1997> 2) Are your dates stored in the database in the form 12/7/1996? If not,>then WebCatalog can't figure out what they -- they could just as well be>random strings of text.Grant,Dates are stored in a db in the format mm dd. I'll try adding togeEventData=Jan 01 and see if that does it. I did not use the year in thedate, because it just didn't seem important.<--Glenn-->~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Glenn & Renee DavisExclusively Web / Net Highway (916) 887-0678Web Page Design / Hosting ServicesPOB 157, Cool,CA 95614-0157http://www.ExclusivelyWeb.comhttp://www.Net-Hwy.com &&& ||| (@ @) (@ @)----------------------------ooO---U---Ooo---------------ooO--(_)--Ooo------->> Mailto:renee@Net-Hwy.com Mailto:glenn@Net-Hwy.com Mailto:renee@ExclusivelyWeb.com Mailto:glenn@ExclusivelyWeb.com Graphics Design Webmaster
Associated Messages, from the most recent to the oldest:
At 3:47 PM 7/13/97, Grant Hulbert altered the fabric of cyberspace,writing:> >I have been trying to get some date sorting correct, but have had only> >limited luck. I am using:> >> >Announcement.tmpl$search?db=Announce.db&geEventDatedata&EventDatesort=1> >&EventDatetype=date&EventDatesdir=de&max=10>> Two things:>> 1) geEventDatedata needs something after it, like geEventDatedata=7/9/1997> 2) Are your dates stored in the database in the form 12/7/1996? If not,>then WebCatalog can't figure out what they -- they could just as well be>random strings of text.Grant,Dates are stored in a db in the format mm dd. I'll try adding togeEventData=Jan 01 and see if that does it. I did not use the year in thedate, because it just didn't seem important.<--Glenn-->~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Glenn & Renee DavisExclusively Web / Net Highway (916) 887-0678Web Page Design / Hosting ServicesPOB 157, Cool,CA 95614-0157http://www.ExclusivelyWeb.comhttp://www.Net-Hwy.com &&& ||| (@ @) (@ @)----------------------------ooO---U---Ooo---------------ooO--(_)--Ooo------->> Mailto:renee@Net-Hwy.com Mailto:glenn@Net-Hwy.com Mailto:renee@ExclusivelyWeb.com Mailto:glenn@ExclusivelyWeb.com Graphics Design Webmaster
Glenn Davis
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:
WebCat2 - Getting to the browser's username/password data (1997)
[CART] inside a [LOOP] (1997)
View Source from cache (1997)
[WebDNA] v7 problem? (2012)
Search for 20 finds 2000, 200 Why? (1997)
processing .html pages (2001)
OT: CT Scan might have saved my life!! (2006)
Card clearance, problems - solutions? (1997)
Convert Chars Q (2000)
Documentation Feedback (1997)
Separate SSL Server (1997)
Dealing with return characters (2004)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
WebCat2b15MacPlugin - showing [math] (1997)
creating an email message (1998)
[WebDNA] Ajax, JS and WebDNA - A joint toturial ;-) (2010)
PIXO support (1997)
UPDATE PROBLEM (1997)
SSL with IIS 4.0 (1998)
[url] - question (2000)