Re^2: Result set into array

yes, I am using DBI. getting error msg "Can't locate object method "selectall_hashref" via package "DBI::st" at ./Test1.pl line 166. "

    $sth = $dbconn->prepare($sql_statement);
    $sth->execute() or die "Can not execute: " . $sth->errstr;

    $sth->{RaiseError} = 1;

    my $hash = $sth->selectall_hashref($sql_statement); #this is line 
+166

    $sth->finish;
    
    $dbconn->commit();

    $dbconn->disconnect();
[download]

Comment on Re^2: Result set into array Download Code

Replies are listed 'Best First'.

Re^3: Result set into array
by shenme (Priest) on Nov 19, 2006 at 02:05 UTC

selectall_hashref()

  my $hash = $dbconn->selectall_hashref($sql_statement);
[download]

  my $sth  = $dbconn->prepare($sql_statement);
      .   .   .   .   .   .   .
  my $hash = $dbconn->selectall_hashref($sth);
[download]

selectall_hashref

  {
    local $dbconn->{RaiseError} = 1;
    my $hash = $dbconn->selectall_hashref($sql_statement);
      .   .   .   .   .   .   .
  }
[download]

[reply]
[d/l]
[select]


Perl Monk, Perl Meditation
	PerlMonks