Re: (Fwd)
From: Jerry Rocteur (macosx_at_rocteur.cc)
Date: 12/18/03
- Previous message: Nilanjan Das: "DBD::Oracle issue on HP-UX"
- In reply to: Paul Dubois: "Re: (Fwd)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 18 Dec 2003 16:59:40 +0100 To: Paul DuBois <paul@snake.net>
On Wednesday, Dec 17, 2003, at 21:44 Europe/Brussels, Paul DuBois wrote:
> At 19:47 +0000 12/17/03, Tim Bunce wrote:
>> ----- Forwarded message from Jerry Rocteur <rocteur@mac.com> -----
>>
>> Delivered-To: tim.bunce@pobox.com
>> Date: Wed, 17 Dec 2003 18:27:12 +0100
>> Subject:
>> From: Jerry Rocteur <rocteur@mac.com>
>> To: Tim.Bunce@pobox.com
>>
>> 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. :-)
>>
>
That did it, thanks a lot, I had that but without the back ticks..
But once I copy pasted your line.. That did the trick!
Thanks very much,
Jerry
- Previous message: Nilanjan Das: "DBD::Oracle issue on HP-UX"
- In reply to: Paul Dubois: "Re: (Fwd)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
