April 05, 2003

Can we sort user detail pages so they're descending by date rather than ascending? Maybe it's my MetaFilter bias, but it seems counter-intuitive to see my very first (naive, virginal) comment at the top (Bledsoe v. Brady is a moot point now). I mention this now because things seem a might confused in a SQL sense. Looking near the bottom (not the top) of my user page, I noticed the grouping is messed up so that multiple comments in a single post are sometimes split into multiple results because a comment in another post happened in between time-wise. Also, can we get the link, italic, bold buttons for Mozilla. [insert stupid pony reference]

posted by yerfatma to bugs at 12:13 PM - 11 comments

P.S. Lockerroom posts ignore linebreaks in preview and posting mode (there should have been one before the last sentence). Comments do not.

posted by yerfatma at 12:14 PM on April 05

In an attempt to be helpful (rather than demanding), here's the code I use for a similar process. It's for MySQL, which doesn't allow subqueries, so it may be wildy inefficient compared to what's available here (if this, like MeFi, runs on SQLServer): 'SELECT [relevant columns from COMMENTS table], [relevant columns from POSTS] FROM COMMENTS as c, POSTS as p WHERE c.userID = 'user_id' AND c.postID = p.postID ORDER BY p.postID DESC' This doesn't tie in the table with user information because I found it inefficient to return x rows of the same user data over and over.

posted by yerfatma at 12:35 PM on April 05

My expert opinion about SQL and the coding required? My cat's breath smells like cat food.

posted by grum@work at 04:31 PM on April 05

I bent my wookie.

posted by Samsonov14 at 05:20 PM on April 05

Sportsfilter: things seem a might confused in a SQL sense

posted by djacobs at 12:31 PM on April 06

When I grow up, I'm going to bovine university!

posted by 86 at 11:56 PM on April 06

You have the bestest Dad. He read me a story about Chinese food.

posted by jerseygirl at 09:36 AM on April 07

Is it just me, or are the link things and other buttons not available for Macs? That's why I have to do this something stupid like this (http://espn.go.com/nba/news/2003/0407/1535067.html) when I want to refer to something other than an initial post. Me fail English? That's unpossible!

posted by wfrazerjr at 02:37 PM on April 07

"Then, the doctor told me that BOTH my eyes were lazy! And that's why it was the best summer ever."

posted by worldcup2002 at 04:19 PM on April 07

This seems like a good idea, but as the only person poking around the code, I may not have time to implement it for a while. It's definitely a pretty easy SQL change.

posted by rcade at 11:19 PM on April 07

And just when I thought the point of this thread was that I could sit around here eating dog food until my tears smelled enough like dog food that my dog came back. Too bad rcade. Could have had me eating dog food.

posted by yerfatma at 06:30 AM on April 08

You're not logged in. Please log in or register.