Here's what I use (a little different):
use DBI;
use diagnostics;
use strict;
my ($dbh,$sth);
my ($dbname)="pickle";
my ($login)="picklesql";
my ($password) ="pi56fb";
my (@ary);
#
$dbh = DBI->connect("DBI:mysql:$dbname",$login,$password)
or die "Can't connect to $dbh: $dbh->errstr\n";
$s
Here's what I use:
use DBI;
use diagnostics;
use strict;
my ($dbh,$sth);
my ($dbname)="pickle";
my ($login)="picklesql";
my ($password) ="pi56fb";
my (@ary);
#
$dbh = DBI->connect("DBI:mysql:$dbname",$login,$password)
or die "Can't connect to $dbh: $dbh->errstr\n";
$sth = $dbh->prepare("SE
The $dbh connect code should be like this:
$dbh=DBI->connect("DBI:mysql:datrtabase=radio';host=localhost",root,"password",
{RaiseError=>1});
If there is an error, you can catch it using, die statement.
Placed At :
John Mayson <[EMAIL PROTECTED]
>From the DBI manual:
$dbh = DBI->connect($data_source, $username, $auth, \%attr);
You're not telling DBI what the DSN is (Data source name)
John Mayson wrote:
>
> I've decided to graduate to the next step and access my mySQL databases with Perl. I
> am attempting this on a Win2000 ma
#x27;, $wert, '$kunde')
^^^ ^
maybe $reader and $wert were not quoted strings
M
-Original Message-----
From: Amer Neely [mailto:[EMAIL PROTECTED]]
Sent: 24 December 2001 15:58
To: MySQL
Subject: Re: Perl Problem!
> Hi!
>
> I have a proplem us
> Hi!
>
> I have a proplem using my perl code to write some data into my mysql
> database. When running in consolemode anything works fine, but when
> executed by the wwwserver the scripts is processed without errors,
> except the data is not written into the database! Any idea how to fixit?
> Th
Hi,
Could it be that no data is written, or read from the files when executing
from the server? Possible your server uses another user then mysql. And the
server has no access to the files, or the permissons set on the files do not
allow them to be read from that user.
You should test it by usin
