Archive for the ‘Tips & Tricks’ Category
Tuesday, March 2nd, 2010
In MySQL, we can easily drop table and check whether it is exist or not using this statement.
DROP TABLE IF EXISTS MyTable
In Oracle, you can’t do that.
Solution that I found is to create a procedure and execute it.
As for my reference and others (if any) here is the script to create that procedure.
(more…)
Posted in Database, Tips & Tricks | No Comments »
Friday, February 19th, 2010
VCF or vCard file is a file format standard for electronic business card. Below are the way how I used to export it to my BlackBerry.
1. Combine all the vcf file into one file. If you are in windows environment you can use below command. Make sure your working directory is correct.
type * > all_contacts.vcf
2. Download and install ABC Amber vCard converter. This software can convert vcf file to ipd file which is recognized by BlackBerry. Click BlackBerry icon to convert the selected contact.

(more…)
Posted in BlackBerry, Tips & Tricks | No Comments »
Monday, February 8th, 2010
For whatever reason, sometimes you will need to change your SVN URL. Perhaps you need to place the server to a new building and change the ip address. After the changes, you cannot commit to that server using your eclipse.
To solve the problem, you can relocate your SVN server and change to the new URL. Look at the image below and you will know that it’s very easy
Open up SVN Repositories perspective in eclipse.

(more…)
Posted in Programming, Tips & Tricks | No Comments »
Sunday, February 7th, 2010
For my team members.
The following works under both IE and FF:
window.onload = function() {
alert(0);
}
Happy coding,
-Just me-
Posted in Programming, Tips & Tricks | No Comments »
Thursday, February 4th, 2010
I just upgrade my wordpress to the latest version. Instead of upgrade it automatically, I choose to manually upgrade and change my url from www.arejae.com/blog to www.arejae.com/blogv2. I also change the theme too.
Old vs New


I’m not sure how long I can keep this theme. I just want to test the performance first and will decide it later.
Migrating all the data from old to my new blog is very easy.
(more…)
Posted in My Life, Tips & Tricks | No Comments »