Am Sonntag, 27. Februar 2005 22.19 schrieb Gerald Preston:
Hi Gerald
> The object used:
>
> my $dbh=DBI->connect( 'DBI:mysql:database=club', 'xxx, 'xxxxx', {
> PrintError => 0} ) or die $DBI::errstr;
I didn't see this part in your first post :-)
Hmm... I've never seen a '=' in the first argument passed to DBI-connect...
Here's an functional example I'm using:
my $db ='database';
my $host ='hostname';
my $port ='1234';
$dbh=DBI->connect("DBI:mysql:$db:$host:$port",
'a_username',
'a_password',
{RaiseError=>1,
AutoCommit=>1})
or die "$0: $DBI::errstr"; }
So, try using "club" instead of "database=club", and a hostname too.
greetings joe
[nothing new below]
> -----Original Message-----
> From: John Doe [mailto:security.department@stripped]
> Sent: Sunday, February 27, 2005 6:37 AM
> To: mysql@stripped
> 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/mysql?unsub=1
