Converting a JavaScript date object to an Excel...
I recently needed to post some data from a web page into a database table. This database table happens to be viewable as a simple html table on a web page. As part of the analysis of the data, the html table of data is inserted into an Excel worksheet as a Web Query. One […]
Read More
Creating a whitelist of recipient email addresses in...
I’ve been getting so much spam recently that I have decided to switch to an “opt-in” approach to receiving emails. I have always set up a new email address whenever I register for something – e.g. companyname@mydomain.com – and previously, these would all arrive into a catch-all address on my email server which catches [anything]@mydomain.com.
Read More
Getting “Freesat From Sky” For Free
The only way those of us with bad Freeview reception (and no cable supplier) can get digital telly is via satellite. For that reason, I’ve been a begrudging Sky subscriber for some time now. Whilst waiting for the BBC to launch their own Freesat offering, I’d considered switching to Freesat From Sky before, but had been put off […]
Read More
Expiry columns and the [Today] value in SharePoint...
I’ve been trying to create some complex views on a custom list in SharePoint 2003. One of the problems is that some items in the list have expiry dates, and some do not. I need to filter the views based on a “category” column, showing only those items which have not expired. Problem is, this […]
Read More
So does the Apple TV support 5.1 audio?
No. And yes. In that order. This article gives the full detail behind what that really means. A little while back, I posted an article discussing the possibilities for the Apple TV supporting 5.1 audio playback. It’s well worth reading that article first, as it talks a little bit about what “5.1 playback” actually means. Now that […]
Read More
Using Subversion and REALbasic for version control
Recent versions of REALbasic contain a new “Version Control Project” format. This saves the project as a whole bunch of text files. With these files, you can use a version control system such as Subversion (SVN) to manage changes in your REALbasic project. This article shows you how to set up Subversion on Mac OS X, create a repository […]
Read More
Encoding Real Media on an Intel Mac with...
At the moment, there aren’t any Intel-native Real Media encoders for Mac. This means that Universal Binary applications running on an Intel Mac can’t encode to .rm files. The main “batch encode” application for Mac – Sorenson Squeeze Compression Suite 4.5 – has this problem. But as ever, there is a solution.
Read More
22 iTunes songs on your iPod
Steve Jobs’s Thoughts on Music article makes for a good read. But I don’t believe that anyone has 22 iTunes Store songs on their iPod, any more than they have 2.4 children. And this is a pretty significant fact. Obviously, Steve isn’t claiming that we all have this magic number of songs on our iPods. What he actually […]
Read More
Detecting iPods programmatically (part 2)
A while back, I wrote a post about detecting iPods connected to your Mac, and finding out their model number in order to deduce information such as the iPod model and colour. Then, in September, Aaron Bockover of the Banshee Project informed me that Apple have changed their approach to storing this information, and no longer store it in an […]
Read More
JavaScript eval in iframes
In the course of developing a new version of log4javascript, I was adding a command line feature that required the ability to evaluate and execute code in an iframe from within the main window. Fine, I thought, I’ll just call eval on the iframe window object. Which predictably worked fine in Firefox and Opera 8+, but did nothing […]
Read More
