Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: DBI and Constant

by MeowChow (Vicar)
on Feb 12, 2001 at 15:56 UTC ( [id://57881]=note: print w/replies, xml ) Need Help??


in reply to DBI and Constant

You probably don't need a constant constant for this; just use a variable. This will simplify your connection string, since you can then use Perl's built-in variable interpolation instead of the clunkier concatenation with a constant value:
our $DBNAME = 'database_test'; my $dbh = DBI->connect("DBI:mysql:database=$DBNAME", 'username', 'pass +word') or die;
Note the single-quotes have changed to double-quotes to allow for the interpolation. From one of your previous posts, it looks like you haven't learned about variable interpolation (excuse my presumptuousness if I'm mistaken :). Interpolation allows you to just type your variable names into double-quoted strings, and have Perl automatically replace the value with the variable's value. You can get a detailed (if not gentle) explanation of this feature in perlop.
   MeowChow                                   
               s aamecha.s a..a\u$&owag.print

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://57881]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (3)
As of 2024-04-26 04:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found