Unable to run Installshield installer

Error Prompt : Error 2103 = Could not resolve path for shell folder

See follow website for resolution
http://www.appdeploy.com/msierrors/detail.asp?id=143

Alternatively like my case, the profile is corrupted so I deleted it off. Next try will take some time later but hope it works.
After login, it defaults to the basic profile and not of the normal profile loaded.
As the installer needs to refer to some registry settings for folder location. Being unable to locate the registry entry for the folders required, the installer fails.....


From OFF2000: "Internal Error 2103" Error Message Is Displayed During Setup
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q302472

This behavior can occur if the following registry key is missing or damaged:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders

Recontract Penalty Charges for all 3 telcos

Singtel

https://www.singtelshop.com/support/support.html

Customers shall be permitted to upgrade their mobile equipment upon expiry of twelve (12) months from the commencement of the Equipment Undertaking Agreement by paying a charge of either $300 (for iPhone & selected smartphones*) or $200 (for all other handsets) in addition to the prevailing price of the mobile equipment

M1

http://www.m1shop.com.sg/Redirect?nextpage=menuterms.jsp&n=Terms%20%26%20Conditions

Additional $100 and $300 applies on the phone offers for customer who have completed at least 11 months of their normal handset contract and/or iPhone handset contract respectively.

Starhub
http://www.starhub.com/support/mobile/faq/mobileservices/recontractpolicy.html

The prevailing Early Handset Upgrade Fee for non – iPhone contracted customers is at $200 and for iPhone contracted customers is $300 or otherwise stated.


in summary -

ST -
change to iPhone and selected smartphones - $300
other phones - $200

M1 -
Previous contract buy iPhone - $300
Previous contract buy other phones - $100

SH -
Previous contract buy iPhone - $300
Previous contract buy other phones - $200

Remove duplicates rows from a table?

SQL> DELETE FROM table_name A WHERE ROWID > (
2 SELECT min(rowid) FROM table_name B
3 WHERE A.key_values = B.key_values);

Javascript checker

Found this site while being lazy to verify the js myself line by line.
Good parser which actually helps the lazy programmer and prevent future maintenance issues. The site is here.

Remove hyperlinks from Excel

I always had this issue with unwanted hyperlinks due to copying from other places, especially a website.

Finally google for an answer and it is a simple VB script, executable by a marco.
If you need it, here is it

Pray for Japan!

There are various ways to donate to Japan in helping them thru the crisis.

A very good thread in Hardwarezone Forum, Eat Drink Man Woman sub-forum if you like to contribute to help Japan.

[PSA] Donate to Japan Tsunami & Earthquake

You can click on the link on the top bar above~!

Opera Mobile Bookmark file

The file is opera6.adr (it should be in My Device/Application Data/Opera9).
Copy out and edit on a normal text editor.