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:
WebCAT has the devil in it! (2003)
Formulas.db question (2002)
WebDNA 4.5.1 Now Available (2003)
WebCatalog for guestbook ? (1997)
More than one db with the same namn (was: WC2f3) (1997)
Search Criteria (2000)
Been meaning to ask... (1997)
[format xs] freeze (1997)
attacment pdf (2001)
Appending Information from one db to another (1998)
Re2: Calculating multiple shipping... (1997)
[ListFiles] Within [LineItems] (2001)
Follow-Up to: Removing [showif] makes a big difference in speed (1997)
web delivery (1997)
SIMS Email Question (2003)
Search results templates (1996)
Security Tip (1996)
[HTML*] (a proposition) (1997)
HTML file size limit (1998)
Max Record length restated as maybe bug (1997)