Re: sorting by date Y2K mix up
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 25854
interpreted = N
texte = >Hello,>>I am having a weird problem with a forum I developped using webcatalog.>New messages created after 01/01/2000 end up showing in a wrong place.>Before january 1st my messages were sorted iin descending order but now>the new messages are zat the end of my list.>>My serach context loks like that :>>[search>db=news.db&neskudata=0&sortorder=de&datecreasort=1&heurecreasort=2&heurecre>asdir=de&datecreasdir=de&max=10&eqpourpagedatarq=bbc&startat=[showif>[startat]![blank]][startat][/showif][hideif [startat]![blank]]1[/hideif]]>>[founditems]>>Any clue ?You don't need the sortorder=de parameter, it is not valid. Also, this code would be cleaner, assuming other things are correct and aassuming you're using version 3.x:[text]startat=1[/text][search db=news.db&neskudata=[blank]&eqpourpagedatarq=bbc&dedatecreasort=1&deheurecreasort=2&max=10&startat=[startat]]However, we still don't know if your dates are stored properly. What is the format of your dates in the datecrea field? Do they all have 4-digit years? What is your DateFormat preference value? What is your ReadDateFormat preference value? Which platform are you on? What beta version are you using?================================Kenneth Grome, WebDNA Consultant808-737-6499, http://webdna.net================================#############################################################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 To switch to the INDEX mode, E-mail to Send administrative queries to
Associated Messages, from the most recent to the oldest:
>Hello,>>I am having a weird problem with a forum I developped using webcatalog.>New messages created after 01/01/2000 end up showing in a wrong place.>Before january 1st my messages were sorted iin descending order but now>the new messages are zat the end of my list.>>My serach context loks like that :>>[search>db=news.db&neskudata=0&sortorder=de&datecreasort=1&heurecreasort=2&heurecre>asdir=de&datecreasdir=de&max=10&eqpourpagedatarq=bbc&startat=[showif>[startat]![blank]][startat][/showif][hideif [startat]![blank]]1[/hideif]]>>[founditems]>>Any clue ?You don't need the sortorder=de parameter, it is not valid. Also, this code would be cleaner, assuming other things are correct and aassuming you're using version 3.x:[text]startat=1[/text][search db=news.db&neskudata=[blank]&eqpourpagedatarq=bbc&dedatecreasort=1&deheurecreasort=2&max=10&startat=[startat]]However, we still don't know if your dates are stored properly. What is the format of your dates in the datecrea field? Do they all have 4-digit years? What is your DateFormat preference value? What is your ReadDateFormat preference value? Which platform are you on? What beta version are you using?================================Kenneth Grome, WebDNA Consultant808-737-6499, http://webdna.net================================#############################################################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 To switch to the INDEX mode, E-mail to Send administrative queries to
Kenneth Grome
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:
Re1000001: Setting up shop (1997)
emailer (1997)
Multiple Passwords (1997)
WebDNA 4.5.1 Now Available (2003)
requiring form fields? (2000)
[format] problem (2001)
WebCat2b13MacPlugIn - syntax to convert date (1997)
From database to email (1999)
More Hide IFs (2000)
Re:What file? (1997)
CSV import suggestions (2007)
SQL & [shownext] tag... (2001)
carriage returns in data (1997)
SKU (1997)
# fields limited? (1997)
Ampersand (1997)
[referrer] tag (1997)
Execute Applescript (1997)
can WC render sites out? (1997)
WCS Newbie question (1997)