Front page | perl.beginners |
Postings from December 2002
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. Getting column names.
Code example; (code sits in a debug sub)
my $sq = $myconn->prepare("show columns from as_codes;");
$sq->execute();
while (@tmp = $sq->fetchrow_array())
{
print $tmp[0], "\n";
}
$myconn is a working connection: the select statements work great.
The above always produces nothing, the while loop never runs. I've also
tried the "describe" sql statement but I get the same results. The table
as_codes has about 12 columns. I even tried the DBI, {NAME} option but got
no columns returned.
If I go into mysql admin and type the above statement then it works. Also,
if I put the above code into a loop and say force it
to perform the operation 10 times, it will work for at least 1 of them.
Is this a bug ? Where can I look next ?
thanks
Craig
Thread Next