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 have a
> working server whic
I have this in a working script runs no problem at all.
Mysql version 3.26 I think.
Do you verify that that the query was executed?
If the query gets bad then it will never get to your while loop.
You could use DBI->trace to see what's going on.
$query = "DESCRIBE $existing_table_name";
Hi,
Ok, I tried what you suggested below and upgraded mysql to the latest
version 3.23.54(stable) and still get no results.
To verify the statements do run, I changed the query to Select * from tablex
and that works fine also added the die statements, no errors.
thanks
Craig
"Dan Muey" <[
Thank You!
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 ;-)
Regards,
Craig
"Jenda Krynicky" <[EMAIL PROTECTED]> wrote in message
3E11A19B.15415.363C20E1@localhost">news:3E11A19B.
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