use ECClib; my $dbh = ECClib::initialise(); my $sql="select InputID from ECCInput order by InputID"; my $sth = $dbh->prepare($sql);