First off, let me qualify what follows with this: I'm a DBI/HTML::TEMPLATE rookie, so be sure to take my suggestion accordingly. At this point, I've noticed no one else has responded, so I thought I'd offer what may be ??? the problem. In your code:

my $rows = $dbh->selectall_arrayref($SQL,{Columns =>{}}) ;

print $rows; <font color="red">(FLow is fine here too-this stateme
+nt prints ARRAY(0x1ed0bb0) )</font>

foreach (@$rows) {
    print "I say $_\n"; (Problem here-no output on screen.)
    }
[download]

I have a program that contains code similar to what you show, but the difference I noticed is instead of:

foreach (@$rows) {
[download]

my program uses ....

foreach (@{$rows}) {
[download]

{note the additional curly brackets} ... could that be it? It's easy enough to try. And if it doesn't work, it seems to me that your problem lies with DBI, not HTML::TEMPLATE, given where things seems to crap out.

Hagbone