insert data

[Gerald Preston]

Hi!

 

I am trying to insert data for the first time using MySQL.  In Oracle I used
the following:

 

#  my $sql = "insert into bar( group_name, me, daily, item, unit, qty,
amount, tax, total )

#                      values( ?,          ?,  ?,     ?,    ?,    ?,   ?,
?,   ? ) ";

  my $sth = $dbh->prepare( $sql );

  die $dbh->errstr if $dbh->err;

 

  $sth->execute( $group_name, $me, $daily, $item, $unit, $qty, $amount,
$tax, $total ) || die "Cannot execute FIRST Statement!!\n$DBI::errstr";

 

I keep getting "Can't call method "prepare" on an un undefined value.  All
the name listed are correct by looking at MySQLAdmin1.3\4.

 

Any ideas?

 

Thanks,

 

Jerry