Hi Gerald, The only thing I can think of is that you have a syntax error in your SQL that hasn't showed up in translation to email. Are you able to select from the database prior to the INSERT? This would confirm that your db has made a successful connection.
The placeholders etc. work exactly as they do in the oracle version of the DBI. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Gerald Preston [mailto:[EMAIL PROTECTED] Sent: Monday, 28 February 2005 7:49 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: insert data The object used: my $dbh=DBI->connect( 'DBI:mysql:database=club', 'xxx, 'xxxxx', { PrintError => 0} ) or die $DBI::errstr; Jerry -----Original Message----- From: John Doe [mailto:[EMAIL PROTECTED] Sent: Sunday, February 27, 2005 6:37 AM To: mysql@lists.mysql.com Subject: Re: insert data Hi Gerald > 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. Apart from David Logan's answer: You have to create the $dbh object first (man DBI); the "undefined value" in the error message refers to that. HTH joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
