On Wednesday, Dec 17, 2003, at 21:44 Europe/Brussels, Paul DuBois wrote:
At 19:47 +0000 12/17/03, Tim Bunce wrote:That did it, thanks a lot, I had that but without the back ticks..----- Forwarded message from Jerry Rocteur <[EMAIL PROTECTED]> -----
Delivered-To: [EMAIL PROTECTED] Date: Wed, 17 Dec 2003 18:27:12 +0100 Subject: From: Jerry Rocteur <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]
Hi Tim,
I'm sorry if this is not the correct way to do this but I just wanted to report something that is worrying me.
Please let me know what I must do if this is not the correct way to report this problem.
I'm on an ENSIM system and my DB name is called rocteur_com-house
I set $db_name to rocteur_com-house then I run this: (I copied parts of
the script the MySQL book by Paul DuBois, the original)
# retrieve reference to single-column array of table names my $ary_ref = $dbh->selectcol_arrayref (qq{ SHOW TABLES FROM $db_name });
I get this error:
<html xmlns="http://www.w3.org/1999/xhtml";
lang="en-US"><head><title>rocteur_com-house Database Browser</title>
DBD::mysql::db selectcol_arrayref failed: You have an error in your SQL
syntax near '-house ' at line 1 at ./db_browse.pl line 86.
</head><body bgcolor="white"><h1>rocteur_com-house Database
Browser</h1><p>Select a table by clicking on its name:</p>
If your database name contains a - character, then you must quote it using backticks. Try: qq{ SHOW TABLES FROM `$db_name` }
I don't think backtick-quoting is mentioned in the first edition of the book, because it hadn't been implemented in MySQL yet. :-)
But once I copy pasted your line.. That did the trick!
Thanks very much,
Jerry
