Ok, firstly - I don't believe this is a mysql issue as I have a working
server which I can prove and the fact I've just learnt Perl was my reason
for posting here, maybe I've screwed up the syntax.
I just installed the modules for DBI and MySQL and they seem to work great
except for one aspect. Ge
To: [EMAIL PROTECTED]
From: "Craig Williams" <[EMAIL PROTECTED]>
Subject: Really stuck: DBI, mysqlPP.
Date sent: Tue, 31 Dec 2002 00:48:44 -
> Ok, firstly - I don't believe this is a mysql issue as I
hile(@row = $sth->fetchrow_array) {
print "$row[0] \n";
}
$sth->finish;
Dan
-Original Message-
From: Craig Williams [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 6:49 PM
To: [EMAIL PROTECTED]
Subject: Really stuck: DBI, mysqlPP.
Ok, firstly - I don
>errstr . "\n";
my $row;
while(@row = $sth->fetchrow_array) {
print "$row[0] \n";
}
$sth->finish;
Dan
-Original Message-
From: Craig Williams [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 6:49 PM
To: [EMAIL PROTECTED]
Subject: Really stuck: DBI, m
t">news:3E11A19B.15415.363C20E1@localhost...
> To: [EMAIL PROTECTED]
> From: "Craig Williams" <[EMAIL PROTECTED]>
> Subject:Really stuck: DBI, mysqlPP.
> Date sent: Tue, 31 Dec 2002 00:48:44 -
>
> > Ok, firstly -
From: "Craig Williams" <[EMAIL PROTECTED]>
> That worked. I had tried the {NAME} option before but I thought it
> returned a reference to the result array and so de-referenced it
> first, probably breaking it ;-)
But the $sth->{NAME} is a reference to an array.
How did you derefe
hehe ok, partly right.
I did; @$fields = $sth->{NAME};
Craig
"Jenda Krynicky" <[EMAIL PROTECTED]> wrote in message
3E11CE1A.16361.36E9ED7D@localhost">news:3E11CE1A.16361.36E9ED7D@localhost...
> From: "Craig Williams" <[EMAIL PROTECTED]>
> > That worked. I had tried the {NAME} optio