(Fwd)

From: Tim Bunce (Tim.Bunce_at_pobox.com)
Date: 12/17/03 

Date: Wed, 17 Dec 2003 19:47:35 +0000
To: dbi-users@perl.org

----- 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>

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 -----

Relevant Pages

  • Re: New Ustafish Listing
    ... >Thanks Tim, ... (Jeff, the FIRST ... >port and report from now till the second Tuesday of the week. ...
    (sci.military.naval)
  • Re: Unbound field in query
    ... Tim ... "Jeff Boyce" wrote: ... >> I am trying to run a query to show certain records on a form. ... the user would select which records to exclude from the report. ...
    (microsoft.public.access.queries)
  • Re: Demon representative on committee?
    ... I suggest you report them often and frequently. ... You are the one with poo on your face for forbidding things you can't enforce. ... You *were* told your charter was unenforceable and I would not be surprised if some people tease you about it. ... You *really* should have thought more at the time, ...
    (uk.net.news.management)
  • Re: DateAdd against textbox value
    ... Tim, there's a problem here with the data type of the text box. ... The best solution would be to add a button to your form for opening the report. ... You can leave the criteria out of the query, and the button will build the WhereCondition string for OpenReport to filter it for the desired month, or show all months if the user did not fill in any date. ... FROM tblClients ...
    (microsoft.public.access.queries)
  • Re: Dear Team (ya think they ever look in ere?)
    ... Ronnie the Tim wrote: ... when you post proof of the events and why, ... ..that's all you've got lies.. ... Who., there is nothing to prove it did happen, not one report, no court ...
    (uk.sport.football.clubs.rangers)