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 Consultant 808-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:

    
  1. Re: sorting by date Y2K mix up (Brian B. Burton 2000)
  2. Re: sorting by date Y2K mix up (Kenneth Grome 2000)
  3. sorting by date Y2K mix up (Laurent Pladys 2000)
>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 Consultant 808-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)