23 November 2006
20 November 2006
19 November 2006
13 November 2006
I had to load some data into our Oracle test database server. The data was created in Excel, exported as CSV files, then read into Oracle using sqlldr.exe (SQL Loader). Pretty straightforward, but sqlldr.exe complained about the date format of some entries and some constraints being broken. It turns out that the date field in the CSV files were "dd/mon/YY" while sqlldr.exe expected "DD-MON-YY" by default. Also, Excel was writing two digit year values, so some start dates were occurring after end dates. For example, if the start and end dates were "1-Jan-2006" and "31-Dec-9999", then they were being written as "1-Jan-06" and "31-Dec-99". Solution was to set the NL_DATE_FORMAT environment variable to YYYY/MM/DD and ensure that the date fields in Excel match them.
I had to be a little careful with setting NL_DATE_FORMAT. In Windows shell, double quotes are treated literally in statements, so use SET NL_DATE_FORMAT=YYYY/MM/DD instead of SET NL_DATE_FORMAT="YYYY/MM/DD" to define the environment variable's value. I guess this will bite you if you come from a Unix environment where the shell treats double-quotes as a string delimiter.
03 November 2006
Just installed latest Firefox 2.0 on my Windows box. It works as expected. Can't see a technical reason why the release number was bumped to "2.0" when there are just a lot of minor changes and fixes.
Having a close button on the right hand side of each tab is more intuitive. Previously, there was only one close button on the right hand side of the Firefox window for closing the currently active tab. I had no problem with that but I noticed my son didn't realise he could close tabs by pressing that button. Score an extra point for usability.
Update: Firefox 2.0 can spell-check text fields. Now I know what rubbish I've been writing.
set nowritebackupbut that didn't work. Puzzled about this problem off-and-on for a couple of weeks. It turns out that I added my settings before
source $VIMRUNTIME/mswin.vim. Duh! My configuration settings were being overrode by the default settings. I moved my configuration settings below those two lines and vim behaved as expected.
02 November 2006
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\CDRom\Autorun= 0. Extra: As usual, once I start looking, I find out more than I need to know in this site.