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:

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)