On Thu, Dec 06, 2001 at 11:31:50AM -0600, Tomasi, Chuck wrote:
> I've got table to track my backup tapes. Each time a tape is used, I log a
> few things about it. I would like to construct a select statement to show
> me the last entry for tape has been.
Do you have to do it in one query? If not just:
@ids = @{$dbh->selectcol_arrayref('select distinct id from tape')};
foreach $id (@ids) {
print $dbh->selectrow_array('select * from tape where id = $id order by updated
limit 1');
}
__END__
dd
--
David Dooling
