-----Original Message----- From: Gerald Preston [mailto:jw...@ont.com] Sent: Sunday, 27 February 2005 9:33 PM To: mysql users Subject: insert data

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,