Sunday 27 January 2013

Whos on Heart 2013 Search List of Guesses & Wrong Answers

If you are following the Whos On Heart competition where you can win £125,000 and want to check the wrong answers and names that have already been guessed then at some point Heart will provide a list of incorrect guesess. In the meantime I thought it would be a useful project to design up a little app to search the names.

But in order to get the list running I need the names guessed each day to be posted so I can add them. I have some info already as well as the answers guessed for 2012 but if anyone can post the names guessed each day that would be really helpful.
The first TWO names have now been guessed - David Duchovny and Jamie Bell. I'm certain that the third name is Dido so if it wins you £125,000 please share some!

Click here to Search List of 2013 Whos On Heart Guesses


Search List of 2013 Whos On Heart Guesses
Search List of 2013 Whos On Heart Guesses

I might even post the name that I'm convinced one of the celebrity voices is - the person saying Whos!



Whos on Heart 2013 Searchable Guesses & Wrong Answers
Whos on Heart 2013 Searchable Guesses & Wrong Answers

The first person to name one of the celebrities wins £10,000, second gets £20k and the one naming all 3 gets £125,000.

The prizes sound very generous but the calls to the Phone line to guess the names cost 50p each. At a rough guess there could be 2000 people calling per hour and 8 chances per day, thats £8000 per day they are making from the calls.

Whos On Heart has been running a month, 6 days per week so potentially 24 x £8000 already made in calls - thats £192,000 in the first month so you can see why they would want to run it for as long as they can.

Obviously these numbers are complete guesswork but as a national competion with a large prize you would expect a lot of entries. Even if they are remotely correct it means that there is absolutely zero cost to Heart from running the Whos On Heart competition.

TomTom Battery Replacement - What Screwdriver to Open?

How to Replace the Battery in a Tom Tom 510 Sat Nav


What Screwdriver do you need to undo screws on a TomTom 510 SatNav?

If your TomTom has stopped working and doesn't hold any charge the chances are that the battery has failed and needs replacement. Our TomTom 510 wouldn't turn on anymore but had previously not lasted very long without being connected to mains power so I thought the battery might be a cause. Checking online it seems that the battery in a Tomtom can last for around 2 years so the 6 years we got from ours was good going!

The price of the TomTom battery on Ebay was £8 and the screwdriver head was £2.50 so for a total outlay of £10.50 we now have a working SatNav and have saved the £100+ cost of a new one!

This guide is an excellent and detailed instruction on how to replace the battery in a TomTom 510 satnav but also should cover other TomTom devices like the 520,710,720 etc.

The only items that I found missing from the guide were to explain that you needed to remove the SD card before starting (found out the hard way!) and which screwdriver you need to undo the screws to open the TomTom up.

Consulting my local hardware store, the excellent Johnsons of Rainham, I was able to determine that the screws needed a T-6 Torx screwdriver to remove them. The cost of this was £2.50 but compared to the hassle the writer of the TomTom battery replacement guide above had it was a doddle to remove the screws and no problem at all to replace them without any of the injuries to the hands that they received.

There are 12 different screws including the 4 on the outside case so it is well worth investing in a proper tool to open them rather than modifying a philips or flat head screwdriver.

What Screwdriver do you need to undo screws on a TomTom 510 SatNav
What Screwdriver do you need to undo screws on a TomTom 510 SatNav
T-6 Torx Screwdriver to undo screws on a TomTom 510 SatNav
T-6 Torx Screwdriver to undo screws on a TomTom 510 SatNav
T6 Torx Screwdriver to undo screws on a TomTom 510 SatNav
T6 Torx Screwdriver to undo screws on a TomTom 510 SatNav

Saturday 26 January 2013

Whos On Heart Wrong Answers - Incorrect Guesses for 2013 - Voices for 2014

Whos On Heart  Competition 2014 - Name these Voices



The Whos On Heart competition is running again for 2013. You can hear the 3 voices saying "Whos" "On" "Heart" here. http://www.youtube.com/watch?v=G_IjTboCMCw

The prize for guessing all 3 secret celebrities is £125,000 so it is a massive jackpot to win!

Click here to Search List of 2013 Whos On Heart Guesses

Eventually Heart will start to show the wrong answers on their website but in the meantime post the wrong answers as replies here and we can build up a list of who has already been guessed for the Who's On Heart Competition.

The first TWO names have now been guessed - David Duchovny and Jamie Bell. I'm certain that the third name is Dido so if it wins you £125,000 please share some!

Thursday 10 January 2013

Oracle Apex Error - Application alias Cannot be converted to unique application id

The Oracle Apex Error  message "application alias can not be converted to a unique application ID.Contact your application administrator" can be encountered if you have the same application alias used on multiple APex Workspaces on the same Apex server.

Apex prevents you using the same Apex Application alias more than once in the same workspace on the same server but doesn't prevent the same alias being used on different workspaces. To check that the application runs correctly use the URL with the application ID not the alias and the app should run without any issues.

If you receive this error then it means another developer has used the same alias on a different workspace on the server. The app runs correctly with the application alias if you are logged into apex admin as you have already specified the Workspace to use. When not logged in the URL must determine which workspace the app relates to.

When the Apex application alias is translated into an application ID it cannot find a unique Id that matches the alias so returns the above error.

The solution to fix the Apex Error message "application alias can not be converted to a unique application ID.Contact your application administrator" is to rename the application alias on one of the applications so that the alias is unqiue on the server. Once this is done then the APex application will run correctly.

Tuesday 8 January 2013

How to Set Field to Uppercase in Oracle Apex

I needed to get a field set to uppercase in Oracle APex (Application Express) so that when a user types into the field any letters entered are automatically converted to capitals.

What appeared to be a tricky task was actually very simple!

All you need to do it to enter the following code into the item element field.

onchange="this.value = this.value.toUpperCase();"

With this code, the user can type into the field in upper or lower case but as soon as they leave the field the content will be converted to capitals / upper case.


How to Set Field to Uppercase in Oracle Apex
How to Set Field to Uppercase in Oracle Apex


The screen shot below is taken from an Oracle Apex 4.2 installation so may look different in other versions.

Wednesday 2 January 2013

VW Golf Radio MP3 Iphone Adapter - Play MP3 Music via Gamma Radio

Do you have a VW Golf Gamma Radio and want to play music from your iPod, MP3 player or Iphone through it using a 3.5mm jack socket adapter?  How to Play MP3 Music via VW Gamma Radio

 
You can buy an attachment that clips into the rear harness of the VW Gamma radio and replaces the output from the CD player so that when you switch to the CD player the line source is played through the radio speakers. I've had this fitted for a few weeks now in my VW Golf Mark 4 and it is fantastic. The fitted CD player was only intermittently working and the radio transmitter iPhone adapter was patchy with interference in many places on my journeys.
 
 
Do you have a VW Golf Gamma Radio and want to play music from your iPod, MP3 player or Iphone through it using a 3.5mm jack socket adapter?

Do you have a VW Golf Gamma Radio and want to play music from your iPod, MP3 player or Iphone through it using a 3.5mm jack socket adapter?

Connects2Adapter Mp3 ipod on VW Gamma radio


Control box for iphone, mP3, iPod adapter for VW Golf radio
Control box for iphone, mP3, iPod adapter for VW Golf radio



How to fit a Control box to play iphone, mP3, iPod adapter for VW Golf radio
Control box & leads for iphone, mP3, iPod adapter for VW Golf radio


3.5mm jack socket allowing music to be played through the VW Golf Gamma radio
3.5mm jack socket allowing music to be played through the VW Golf Gamma radio
This is a similar adapter for VW Golf Mark5 Radio MP3 Iphone Adapter
http://www.ebay.co.uk/itm/VW-GOLF-AUX-IN-INPUT-ADAPTER-INTERFACE-CABLE-LEAD-CAR-RADIO-IPOD-MP3-3-5MM-JACK-/360549569833?pt=UK_In_Car_Technology&hash=item53f26dd529