Nuts and bolts about programming applications, databases and spreadsheets. Note: Comments are moderated to filter comment spam. Mobile version
2005-09-29
Software: Winzip In-place Editing Annoyance
2005-09-28
Software: WinCVS Locate File Feature
When using WinCVS, sometimes I want to copy the path of a file so that I can tell a developer which file to change by e-mail. By accident, I found that WinCVS would print the location of a file in the Output pane if I drag and drop a file in the File Pane. In the illustration, the top right hand pane is the File Pane and the Output Pane is the bottom pane.
2005-09-22
Software: Simple Javascript Regular Expression Search and Replace
Here's a simple regular expression search and replace in Javascript (for JScript, replace alert with WScript.Echo). I wrote it as a test for another script to modify a configuration file.
var s1 = "Hello World" var s2 = s1.replace(/Hello/, "Goodbye") alert(s1 + "," + s2) var s3 = s1.replace(/(Hello)/, "$1 Googly") alert(s1 + "," + s3)
If you run this script in a Web page, you should see the first alert dialog containing "Hello World,Goodbye World" and a second alert dialog containing "Hello World,Hello Googly World".
In this example, the parentheses (()) enclose a match pattern and the dollar ($) symbol represents the matched string (i.e. $1 is the first matched string, $2 is the second matched string, etc.).
2005-09-19
Software: Oracle ORA-12638 Credential retrieval failed
Sometimes the Oracle server throws an ORA-12638 error after I drop tables from a database with active connections and subsequently try to run SqlPlus on the server computer. My previous solution was to reboot the Windows server computer. Hey, when in Windows, do what the locals do.
A better solution can be found here. Since Oracle administration is not my game, I'll just accept that Martti's solution works and not ask any more questions.