Watashi wa pengin desu.
Minä olen pingviini.
keskiviikko 17. syyskuuta 2008
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.
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)
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;
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
;
product,
company,
case when category = 'Microsoft'
then 'Yes!!'
else 'No'
end as microsoft_spotted
from
products
;
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
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 /?
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.
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
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
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
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
What a nice thing to see first thing at work. Full 640x505 pixels with *four-bit* color depth. Deep. I am taken, so delightful :(
sunnuntai 27. tammikuuta 2008
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
Tilaa:
Blogitekstit (Atom)