Alan J. WilliamsOnline profile

Came across this anomaly today for the first time. Extending a form where the label tag defined a row with several radio buttons inside, for the basis of providing a rating system from 1-5.


Rate this (1-5)



In Firefox this demonstrates some weird behaviour where by if you click the 4th one, it’ll generally just select the first one, unless you vehemently keep clicking to get it to the correct value. Oddly this is valid HTML and works fine in IE, Opera and Chrome (and presumably Safari).

Read the rest of this entry »

Today I was writing a query to retrieve a number of records in a table which were associated to several different identifiers from a second table, which in turn were resolved from a third table.

I had a quick look on line to see if there were any quick examples I could start the basis off, but most examples were for just obvious queries or single count(*) and misrepresented. So I have an example of my solution below:

SELECT
	COUNT(1) as "Count",
	table2.name as "Name"
FROM table1
LEFT JOIN table2 on table2.id = table1.table2id
WHERE table1.table2id IN
(
	SELECT table2.id FROM table2 WHERE table2.field2='clause'
)
GROUP BY table2.name

Read the rest of this entry »

Started working at KMP Digitata this month.  The post is working as a web developer so gives me the opportunity to work with new technologies and learn more about web application servers past my previous experience with JBoss. Things are going well but once again means that personal projects are on hold, currently enjoying my free time away from the codeface!

After development on my own site had slowed a bit, I decided to step back and use a fully fledged dedicated CMS on my domain.

I’ve used WordPress before but never much enjoyed my experience of it. The back-end is a overly comprehensive and I find it to be filled with a large amount of guff that isn’t easily removed.

However, in the past couple of months, after dabbling in it for a client, I’ve managed to realise the potential to hack and customise the CMS to my own needs. It’s something new to work on anyway.