perl-programmer-john's Journal perl-programmer-john's use Perl Journal en-us use Perl; is Copyright 1998-2006, Chris Nandor. Stories, comments, journals, and other submissions posted on use Perl; are Copyright their respective owners. 2012-01-25T02:44:07+00:00 pudge Technology hourly 1 1970-01-01T00:00+00:00 perl-programmer-john's Journal Win32::GUI Snarl and Windows Media Player Last month I experimented with SendMessage (Win32::GUI) to control Snarl (<a href="">Snarl with Perl</a>) and Windows Media Player (<a href="">Using application command events with Perl to control Windows Media Player</a>). I want to look further into interacting with Windows applications and DLLs this month so stay tuned. perl-programmer-john 2007-02-08T17:54:55+00:00 journal The index entry exceeds the maximum length of 900 bytes <p>Ok, this sounds like an MS SQL issue, which is right. In itself it's interesting, since I use Perl to "talk" with MS SQL, and I wrote some Perl snippets to show you how: <a href="">The index entry exceeds the maximum length of 900 bytes</a> </p><p> What makes it more interesting is that while writing the entry I found a fix for the "Invalid character value for cast specification (SQL-22018)" error I got in an earlier attempt, by explicitly setting the column type using the DBI bind_param method. One day it might bite you, and hopefully you'll remember the solution.</p> perl-programmer-john 2006-03-13T07:54:47+00:00 journal Removing Processing Instructions and Comments from XML using Ages ago, well... months ago, someone asked on Usenet for a small example that uses XML::Parser. I first gave a link to an example on my site: <a href="">Finding the number of unique XML elements in files using XML::Parser</a> but the author of the original post asked for a simple example showing how to remove processing instructions (PIs) and comments, so I posted a small working example, see <a href="">Removing Processing Instructions and Comments from XML using XML::Parser</a> perl-programmer-john 2006-03-10T04:33:18+00:00 journal Create an RSS web feed automatically Today I wrote a small script which scans the document root and creates an RSS feed automatically based on the last modification time of the given number of HTML files and some info extracted from those files. See <a href="">Create an RSS web feed automatically</a> perl-programmer-john 2005-12-07T05:50:34+00:00 journal Googlebot statistics - analyze your access log with Perl <p> Today I did a quick hack: a short Perl program to analyze my access log. It generates output I can import in Calc ( When I was happy with its output, I decided to make it available via my personal website, see: <a href="">Googlebot statistics</a> </p> perl-programmer-john 2005-12-04T02:45:07+00:00 releases