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:
Search design (1997)
Issue with plug-in Webcat, webstar 4.x, SSL and IE when using the backbuttom (2000)
[OT] Browser's search via javascript? (2003)
[search] and [shownext] Problem (2000)
Frames and WebCat (1997)
WebStar Secure on other machine (1997)
WebCatalog Hosting (1996)
Satistics (1999)
RAM problems, [appendfile] problems (1998)
Just a test - please ignore (1999)
Plugin or CGI or both (1997)
Items XX to XX shown (1997)
Search wbrk (repost) (2001)
pop up menu's (1998)
carriage returns in data (1997)
WebMerchant Setup: Which card processor to use? (2000)
Text data with spaces in them... (1997)
ShowNext for method=POST (1997)
More e-mail testing... (2000)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)