KBD

Keith Devens .com

Sunday, July 20, 2008 Flag waving
Lisp is worth learning for the profound enlightenment experience you will have when you finally get it; that experience will... – Eric S. Raymond
← Entry 1620Entry 1622 →

Daily link icon Tuesday, March 12, 2002

Entry 1621

If you haven't already noticed, I added a "recent comments" section down to the right. The goal is to have it show all recent entries (those whose parent post still shows on the main page), grouped by post, showing the most recent entry for each post. Problem right now is that I can't figure out how to get the most recent entry for each post before it groups by the entry, so it's showing the first comment for each entry.

Curses! I think it's impossible to do what I want to do without using sub-selects. I've been poring over my SQL book tonight, and I haven't found a solution. I'll have to write procedural code to do it.

Hey, at least PHP allowed me to write functional-style code, thanks to in_array() and array_push().

← Entry 1620Entry 1622 →

Comments XML gif


Feel free to post a comment below. Please see my comment policy.

Formatting Rules (No HTML):

  • **bold**, *italic*, _underlined_, --strikeout--
  • "text"="url" creates a link, and URLs are auto-highlighted
  • Blockquote: Like e-mail, begin paragraph with > (greater-than sign)
  • Lists: begin paragraph with *,-, or + (unordered), or # (ordered)
  • Code block: ?!code:language=perl|php|sql|javascript|etc.{\n}...{\n}?!/code

:
(will be your IP address if blank)
: (optional)
(Will not be shown on site)

: (optional)
:

July 2008
SunMonTueWedThuFriSat
 12345
6789101112
13141516171819
20212223242526
2728293031 



RSS feed RSS feed for Keith's Weblog
Atom feed Atom feed for Keith's Weblog
Weblog archive
Recent comments
  on 2 posts

Recent comments XML

Spider solitaire

To answer an earlier question, I am​almost certain every game can be​beat. ...

Jared: Jul 16, 2:20pm

I hate Norton Antivirus

I HATE NORTON ANTIVIRUS IT SUCKS I​GOT AVG IT ROX! AGES TO DELETE​NORTON AN...

wade: Jul 15, 1:44am

Generated in about 0.215s.

(Used 8 db queries)

mobile phone