... can be written ...

  $s->ar   = $sth->fetchall_arrayref({});
  $s->rows = @{$s->ar};
[download]

Excellent. I've been looking for fetchall_hashref for ages! This is exactly what I need - I also use a template system (not HTML::Template) and it can do the same trick with arrayrefs of hashrefs (or arrayrefs).
I guess I should look into converting my stuff to use bind_columns. Is there any (efficient) way you could tie an array to the results do you think?

Thanks Matt.

- Rich