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-
curhat, umpatan, makian, kritik sosial, atau hanya tulisan biasa saja. dari seorang yang "luar-biasa biasa" (alias sangat biasa, alias biasa-biasa saja)
-
| Artikel Personal |
| Windows |
| Berbagi Catatan |
| Artikel Umum |
| Album Pribadi |
| Script Collection |
Kamis, 06 September 2012
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:
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-
In other words, this will manipulate the domain name of your local PC before the computer requests to DNS Server.
Windows:
- goto c:\windows\system32\etc\drivers\
- edit a file named "hosts"
- add the point to your IP address with your preferred name
- goto /etc
- edit a file named "hosts" (use sudo gedit hosts)
- add the point to your IP address with your preferred name
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-
"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-
Langganan:
Postingan (Atom)