Kamis, 06 September 2012

SQL: Insert Into Table From Other Table

if you find error when executing:
 "insert into yourtable values(select col1,col2,col3 from yourothertable)"

use this statement instead of this:
 "insert into yourtable select col1,col2,col3 from yourtable"

you don't need to add values on your SQL.

thanks.
-ok-

Senin, 27 Agustus 2012

Manipulating DNS Alias at Local Computer

To change display name at local computer without registering the DNS Server, you can edit the hosts files.

In other words, this will manipulate the domain name of your local PC before the computer requests to DNS Server.

Windows:
  1. goto c:\windows\system32\etc\drivers\
  2. edit a file named "hosts"
  3. add the point to your IP address with your preferred name
Linux:
  1. goto /etc
  2. edit a file named "hosts" (use sudo gedit hosts)
  3. add the point to your IP address with your preferred name
This way is only manipulate the domain name in local computer,
for example if you add 192.168.0.123 with name yourdomain.com, then you open the internet browser and browse to http://yourdomain.com, you'll get the website of 192.168.0.123

-ok-

Selasa, 31 Juli 2012

MS Outlook 2007: Operation failed, object could not be found

When you found this error in MS Outlook 2007:
"Operation failed, object could not be found"
and you've searched the solutions, you may dissapointed because it could not solve your problem.

you can try this steps as alternative:
1. Look for outlook.exe file, usually c:\program files\microsoft\office12\outlook.exe
2. Right click the outlook.exe file, and click properties

3. click the compatibility tab, and uncheck the compatibility mode, so it will not run in compatibility mode

that's all, you can try this one. -ok-