Keith's Krazy Web Site
Keith's Krazy Web Site
Keith Carangelo
Personal site for Keith Carangelo
Latest Posts
Our install process involves updating the CVS versions of individual files on the staging and ultimately production servers. Web Operations is responsible for manually updating the files listed on an electronic install form. After over...
One feature of almost every modern commercial website is the location finder. Enter in a search address, and site displays the closest locations to it with the distances (as the crow flies). I ran into a couple of peculiar bugs trying to...
At work, we use Microsoft SQL Server and IBM AS400 databases. Here’s how I set our Linux boxes to allow them to connect to the databases through ODBC. There are seperate instructions for the Debian and Ubuntu (9.10 Karmic Koala) and Red...
We’re having an issue with database queries to the iSeries AS400 through Perl using DBI and DBD::ODBC. The issue occurs when the SQL statement contains an outer join and the query returns rows with NULL columns: my $sql_query = qq|select...
Here are a couple of tricks to remember when using jQuery’s tablesorter plugin with dynamic tables. These are tables that the user can add or delete from. If the table begins empty (with no rows in <tbody>), you can’t specify a default...
Like the fellow that never read his car’s owner’s manual, I had never read the entire Perl FAQ. I finally did it over the holidays, and these are some notes that I took. Time::Piece – CPAN module that provides object oriented time...
When I execute a CVS update command at work, I often get the following error: [caran@mater safetypublic]$ cvs -q update -AdP : No such file or directoryectory /home/cvs/safetypublic/rsvp cvs update: skipping directory rsvp No such...
Awhile back we had an issue where a coworker wanted to use one of my Perl CGI scripts inside of her scripts, using the backticks method to have it spit its output to the webpage. But for some reason, my script refuse to recognize the...
For years, I’ve been searching for a suitable terminal emulator for Cygwin, but nothing seemed as polished or had enough features to pull me away from the boring default. I finally found the Holy Grail in a program I’ll call Java...
We have a Perl CGI script at work that acts as a proxy. It grabs a pkcs12 digital certificate file from an internal server and delivers it to a user through his or her web browser. The pkcs12 file is in binary format. Everything worked...
Here are some random Perl things I always need to look up: Print the string representation in hex print join( ’ ', map { unpack “H*”, $_ } split( //, $x ) ); Text replacement on a per-file basis perl -pi -e...
Hand history files, like computer programs, are notoriously difficult to read. Software developers use syntax coloring to highlight keywords and contrast different sections of code. I've developed a syntax definition file for the Vim...
Recently, I was asked by my employer to write an Apache module. The module reads the requestor’s digital certificate and checks it against our database of active users. In this post, I’ll explain how to get started writing Apache...
Splitting a Perl application into seperate files can be trickier than doing it in other languages, like C or C++, but it is still an important part of producing maintainable code. Creating the Package A Perl module is a collection of...
This is an H2 Heading From Moby Dipsum… Call me Ishmael. Some years ago—never mind how long precisely—having little or no money in my purse, and nothing particular to interest me on shore, I thought I would sail about a little and see...