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:
[math] show=F exists? (1997)
[showif]/[hideif] question (1997)
Variables for chat (1997)
Help name our technology! (1997)
OT: Limit on # of Pulldown entries (1997)
[WebDNA] A new popuated field to a DB with 700.000 records (2009)
Showing once on a founditems (1997)
[ConvertChars] problem (1997)
WebCatalog can't find database (1997)
Performance Issue (2000)
emailer don't work (1998)
Correction: shipCost (2000)
New NT betas available (1997)
WebCat chatroom (1997)
CommandSecurity? (1997)
OT: CT Scan might have saved my life!! (2006)
[WebDNA] [OT] Need to add second SSL host - what are my options? (2010)
Sami (1998)
WebDNA with WebStar V (2003)
WebCat2 - [format thousands] (1997)