keskiviikko 17. syyskuuta 2008

Watashi wa pengin desu.

Watashi wa pengin desu.
Minä olen pingviini.

torstai 17. heinäkuuta 2008

Easy way to convert audio-only ASF to MP3 / WAV

Follow these steps:
1) Download and install latest version of Goldwave
2) Open ASF-file with Goldwave
3) Save it to WAV or MP3. There are many other formats, too.

Suggested bitrate for new MP3-file is same as the original ASF-file had.

Note, Goldwave uses LAME MP3 Encoder, so Goldwave will ask for "lame_enc.dll" at the first run. If you don't have it already, download it from The LAME Project page.

maanantai 19. toukokuuta 2008

ts2bluray (dvd)

Mini-ohje miten HD Transport Stream (.ts) "muutetaan" Blu-ray-yhteensopivaksi ja poltetaan DVD:lle. Blu-ray -levyä ei tarvita. Toimii Playstation 3:ssa ja Blu-ray soittimessa. Mutta Blu-ray soitin testattu.

torstai 3. huhtikuuta 2008

Replace a string in Oracle database field

update myTable a set someField = replace (a.someField,'Ä','A') where someField is not null;
update myTable a set someField = replace (a.someField,'Ö','ö') where someField is not null;
update myTable a set someField = replace (a.someField,'Å','A') where someField is not null;

Oracle Case-When example

select
product,
company,
case when category = 'Microsoft'
then 'Yes!!'
else 'No'
end as microsoft_spotted
from
products
;

List all tables in your Oracle database

select owner, table_name from all_tables;
select * from all_tables;
more on ss64.com

Howto register Dll and Exe in command-line

To un/register Dll:
c:\>regsvr32 "C:\Windows\System32\My.dll"
c:\>regsvr32 /u "C:\Windows\System32\My.dll"

To un/register Exe:
c:\>"C:\Program Files\MyAppLocation\My.exe" /REGSERVER
c:\>"C:\Program Files\MyAppLocation\My.exe" /UNREGSERVER

to kill a process from taskmanager from command-line

First you should check that process is really found at taskmanager. You can list processes with command TASKLIST. To kill a process use TASKKILL.
E.g. c:\>tasklist
To kill a process if you know it's process id (PID)
E.g. c:\>taskkill /pid 12345
To kill a process if you only know it's name
E.g. c:\>taskkill /im "winamp.exe"
To find a process if you know partial name
E.g. c:\>tasklist /fi "imagename eq win*"
For more examples
E.g. c:\>tasklist /?
E.g. c:\>taskkill /?

Some Error messages with possible solution in asp-pages

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Solution:
You have mistyped your your database name. Check from tnsnames.ora it exists and is working. Check you can connect to database with SQLPlus.

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Unspecified error
/website/some.asp, line 13
Solution:
Your database is not running. Start your database. Check you can connect to database with SQLPlus.

sunnuntai 30. maaliskuuta 2008

Windows Vista Shell Folders

Originally published at:
How-to-Geek

You can easily get to various shell folders by entering one of these into the address bar:

shell:AddNewProgramsFolder
shell:Administrative Tools
shell:AppData
shell:AppUpdatesFolder
shell:CD Burning
shell:CSCFolder
shell:Cache
shell:ChangeRemoveProgramsFolder
shell:Common Administrative Tools
shell:Common AppData
shell:Common Desktop
shell:Common Documents
shell:CommonDownloads
shell:CommonMusic
shell:CommonPictures
shell:Common Programs
shell:Common Start Menu
shell:Common Startup
shell:Common Templates
shell:CommonVideo
shell:ConflictFolder
shell:ConnectionsFolder
shell:Contacts
shell:ControlPanelFolder
shell:Cookies
shell:CredentialManager
shell:CryptoKeys
shell:Default Gadgets
shell:Desktop
shell:Downloads
shell:DpapiKeys
shell:Favorites
shell:Fonts
shell:Gadgets
shell:GameTasks
shell:Games
shell:History
shell:InternetFolder
shell:Links
shell:Local AppData
shell:LocalAppDataLow
shell:LocalizedResourcesDir
shell:MAPIFolder
shell:MyComputerFolder
shell:My Music
shell:My Pictures
shell:My Video
shell:NetHood
shell:NetworkPlacesFolder
shell:OEM Links
shell:Original Images
shell:Personal
shell:PhotoAlbums
shell:Playlists
shell:PrintHood
shell:PrintersFolder
shell:Profile
shell:ProgramFiles
shell:ProgramFilesCommon
shell:ProgramFilesCommonX86
shell:ProgramFilesX86
shell:Programs
shell:Public
shell:PublicGameTasks
shell:Quick Launch
shell:Recent
shell:RecycleBinFolder
shell:ResourceDir
shell:SampleMusic
shell:SamplePictures
shell:SamplePlaylists
shell:SampleVideos
shell:SavedGames
shell:SearchHomeFolder
shell:Searches
shell:SendTo
shell:Start Menu
shell:Startup
shell:SyncCenterFolder
shell:SyncResultsFolder
shell:SyncSetupFolder
shell:System
shell:SystemCertificates
shell:SystemX86
shell:Templates
shell:TreePropertiesFolder
shell:UserProfiles
shell:UsersFilesFolder
shell:Windows
Blogged with the Flock Browser

torstai 13. maaliskuuta 2008

Windows Vista by command-line : openfiles

Openfiles command is usefull tool to query open and shared files.

E.g.
C:\>openfiles /query /v
C:\>openfiles /?


original link techrepublic.com

Windows Vista by command-line : systeminfo

With systeminfo command-line tool you can get some technical information and Service Packs (Hotfixes) installed on your Xp or Vista.

E.g.
This will collect all the data and outputs it to file systeminfo.log. It will be opened also.
c:\>systeminfo > systeminfo.log && start systeminfo.log

Original link: techrepublic.com

Blogged with Flock

torstai 31. tammikuuta 2008

Desktop of my Windows XP


Desktop of my Windows XP
Originally uploaded by nuux
What a nice thing to see first thing at work. Full 640x505 pixels with *four-bit* color depth. Deep. I am taken, so delightful :(

Asian Laptop


PICT9868
Originally uploaded by Luke Luo
Another Hewlett-Packard laptop I like to have, on my lap =)

sunnuntai 13. tammikuuta 2008

JSON example

{
"etuNimi": "Matti",
"sukuNimi": "Virtanen",
"osoite": {
"postiToimiNro": 000100,
"postiToimiPaikka": "Helsinki",
"katuOsoite": "Lahnakuja 3 B 7"
},
"puhelinNumerot": [
"09-1234567",
"040-1234567"
]
}

lisää JSONista, suomeksi

keskiviikko 9. tammikuuta 2008

Getting Started with Flock | Flock

blog post test from Flock

Blogged with Flock