Category Archives: Programming

notes on how (not) to do programming

Group on table joins

This is one of the more confusing issues of table joins. To make it extra confusing, try an outer join: Select * from ta as a left outer join tb as b on a.key = b.key Both tables have duplicate … Continue reading

Posted in Programming | Comments Off on Group on table joins

How to select/display all rows with duplicate values in MySQL

(This should be a fub, but the description is too long.) One of the most frequent uses of database tables is to identify duplicate values in your data. Assume you have a table with a list of names, and you … Continue reading

Posted in Programming, software | Comments Off on How to select/display all rows with duplicate values in MySQL

Capturing system command output in perl

Running system commands from inside a perl script is one of the nastiest of all perl headaches. I suffered grievously when trying to use this method with some pdf file addons, and have scars to show for it. Lately, having … Continue reading

Posted in Programming | Comments Off on Capturing system command output in perl

Fixing textwidth in vim

I have had several problems with my program editor Vim recently.  Here is how I fixed one of them. There are two directories that I had to mess with: c:\program files\vim [vim directory] c:\users\rabbit [user directory] the vim directory is … Continue reading

Posted in Programming, software | Comments Off on Fixing textwidth in vim

Mechanized Moodle

One of the main things I use Perl for is to manage my grading chores on Chi Nan University’s Moodle system. Moodle is a very useful teaching tool, one I’ve been using for over 10 years. So if it’s such … Continue reading

Posted in Programming, school | Comments Off on Mechanized Moodle

perl win32 OLE arcana: 1

problems with perl Win32 OLE: error 0X800a03ec Continue reading

Posted in Programming | Comments Off on perl win32 OLE arcana: 1

UTF-8 and utf8: Another piece of the puzzle

A case where UTF-8 and utf8 in perl made an important difference. Continue reading

Posted in Programming | Comments Off on UTF-8 and utf8: Another piece of the puzzle

Stupid programming tricks: #1

how to redirect messages and errors from your perl script to a file in the same order that they appear on your screen. Continue reading

Posted in Programming | Comments Off on Stupid programming tricks: #1