Thank you, I'm well aware how this site works with regards posting and displaying code. If you click the download link provided you get the code exactly as you have submited it to the site.

This confusion aside, here's a couple of points:

• You're ignorning the fact that I call your example with -c, meaning I'm compiling it only, not running it. I don't execute it. Your statement regards different databases is irrelivant. See perlrun, look for -c
• You're either ignoring or don't understand the error messages I posted, which clearly show that the $dbh variable has not been declared as my $dbh. See strict.

The example you posted DOES NOT WORK. You must be running code which is different to the code you posted.