Pages
Categories
Old Posts
- May 2010 (2)
- March 2010 (1)
- February 2010 (1)
- December 2009 (4)
- November 2009 (1)
- October 2009 (1)
Author Archives: david
John Cleese on Proportional Representation
Given the kind of crap we are bound to see and read in the next few weeks, here is an explanation of the real issue:
Posted in Uncategorized Tagged general election, it's a joke, PR, proportional representation Leave a comment
Capitalise all Words in VBA
Easy to do with Pearl-type regular expressions but a knotty problem in VBA. I present an elegent solution that utalises VBScript regular expression 5.5 and can handle real names with apostrophies and hyphens.
The Most Truth That I Know
If we could conquer greed then we would conquer need.
This is the most truth that I know.
I only wish it could be so.
Some cool Flash widgets
Just came across some cool Flash widgets on abowman.com, check them out.
Pengiuns: they follow your mouse around.
Fish: click on the pond to feed the fish
[edit]turns out it was the FollowSite plugin that was slowing up my blog – lousy plugin that does not work[/edit]
Posted in Uncategorized Leave a comment
Play a game and donate water
Try it out: Play a game online and do some good while you’re at it.
Posted in Uncategorized Leave a comment
Act on Global Warming
Get active about global warming and the failure of the Copenhagen conference, click the logo and send an email to our ‘leaders’.
/* begin styles for RSS Feed */
.rss-box-action {
margin: 0em;
width: 160px;
background-color: #E2EBD8;
/* Change above line to changer background color [...]
Calculate the Running Balance
How to calculate the running balance on a ledger using self-joins.
Find user’s most recent post in each thread
One common problem that my sequence method can help to solve is how to display the most recent entry that a user has made in each thread that the user has contributed to:
SELECT * FROM posts WHERE usedid = $userid AND postid IN
(SELECT t1.postid, COUNT(t1.postid) AS sequence, t1.postid <= t2.postid AS flg
FROM posts t1 INNER [...]
How to Sequence each Sub-set of Records
How to find/display/keep/delete the first/last n posts/records/entries for each user by using a sequence.
Der!!