I'm unfamiliar with what the square brackets accomplish for Access, but that's the gist of it. You don't want do
though, because you don't get a statement handle back from that. You need to either use prepare
, and one of the fetch...
methods like fetchall_arrayref
or you need to use one of the selectall...
methods such as selectall_hashref
my $sth = $dbh->prepare( "select ?,? from ? where ? = ?" );
$sth->execute( '[is Active?]' ,'[is Deleted?]', '[is Deleted?]', 1 );
my $array_ref = $sth->fetchall_arrayref;