When do we receive 0E0

bchanan · #1 (**permalink**) 11-23-10, 03:17

Hello All,

I am trying to figure out, the value received when doing: do / selectall_hashref, selectall_arrayref...

N - number of effected rows
0 - no record was effected
undef - ?
0E0 - ?

thanks
Chanan

spacebar · #2 (**permalink**) 11-23-10, 18:23

You can just loop through the results, printing and/or counting them.

This is an example using 'selectall_hashref':

Code:

$sth = $dbh->prepare('SELECT * FROM exmpl_tbl');
$results = $dbh->selectall_hashref('SELECT * FROM exmpl_tbl', 'id');
foreach my $id (keys %$results) {
  print "Value of ID $id is $results->{$id}->{val}\n";
}

This is different example using 'selectall_arrayref':

Code:

my $sql_stmnt = "SELECT * FROM emp WHERE emp_id = ?";
my $emps = $dbh->selectall_arrayref($sql_stmnt, undef, '1234');

foreach my $emp (@$emps) {
   my ($emp_id, $emp_name) = @$emps;
   print "$emp_id - $emp_name \n";
}

hth

Internet Services

Web Development

Digital Marketing

Consumer Tech