----- 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>
I've tried to escape the _ and the - with no success..
So it seems that DBI spits with this function .. Apart from that every
thing seems to be working OK..
I've tried on:
perl -MCGI -e 'print "CGI.pm version $CGI::VERSION\n";'
CGI.pm version 2.752
and CGI.pm version 3.00
Again I apologize if this is NOT the correct way to report a problem.
Best Regards,
Jerry
----- End forwarded message -----
