ArticleListing

philthy · March 24th, 2009, 09:30 AM

In TheBeerHouse, the articles in ArticleListing are listed with the newest entry first. I expect this is because of the Order By ReleaseDate DESC clause in the SP. However, If I change this to Order By ReleaseDate ASC, the articles are still listed as before. TheBeerHouse use a GridView in ArticleListing.

In my Blog application, I use a ListView in the ArticleListing control, and I use the same Order By ReleaseDate DESC in my SP, but my articles are listed with the oldest first... Changing the Order By clause has no effect. Whether I use paging or not has no effect either

Is the order defined somewhere else?

jimibt · March 24th, 2009, 10:01 AM

philthy,

can't remember the TBH sp's/sql that well but it could well be that the cache hadn't expired after you made the change and therefore you were still getting the 'old' list from the BLL, rather than the refreshed DAL->BLL list...

just a thought...

Lee Dumond · March 24th, 2009, 10:36 AM

Ditto to what Jimi said; that was my first thought.

philthy · March 24th, 2009, 01:44 PM

I was thinking of cache issues too, but I just assumed that it would work "out of the box" so to speak, if I kept the order by clause as Order By ReleaseDate DESC, just as in TheBeerHouse. Ill try playing around a little and write back...

Thanks guys...

jimibt · March 24th, 2009, 04:55 PM

philthy - it won't work 'out of the box' in this way as your edits were code edits, rather than data edits.

frustrating stuff i grant you and an area that i've addressed by creating a master 'reset' across the cache when i'm testing projects for this very reason.

so you see, 'you're not alone'!!

philthy · March 25th, 2009, 07:40 AM

Ok, I'm not sure if I dare to tell what was wrong here. Turns out the error was located a couple of feet from the keyboard...

Since I'm still testing my application, every time I added a new article, I just entered the same release date, because it was easier to just click on the textbox and enter the previous value. As a result, all articles had the same release date, and thats why the newest entry came in last on the list..

Go ahead, laugh all you want...

philip_cole · March 25th, 2009, 08:28 AM

OK then,

Don't worry, you're not a proper programmer until you've done something totally dumb. Welcome to the elite

philthy · March 25th, 2009, 08:38 AM

Well, in that case, I must be really good

Thnx

Lee Dumond · March 25th, 2009, 09:32 AM

Quote:

Originally Posted by philthy

Ok, I'm not sure if I dare to tell what was wrong here. Turns out the error was located a couple of feet from the keyboard...

Since I'm still testing my application, every time I added a new article, I just entered the same release date, because it was easier to just click on the textbox and enter the previous value. As a result, all articles had the same release date, and thats why the newest entry came in last on the list..

Go ahead, laugh all you want...

Okay, so this was my SECOND thought...