Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: concatenating variables

by suaveant (Parson)
on Jul 31, 2012 at 17:41 UTC ( #984634=note: print w/ replies, xml ) Need Help??


in reply to concatenating variables

There are ways to do this but it is generally considered bad practice to do so unless you have no other choice. Consider instead an array.
$lines[0] = "use pricedb"; $lines[1] = "second statement"; for my $sql (@lines) { $dbh->do($sql); # check code here }
That easily lends itself to pulling queries from a file or building queries programmatically. It also means you can have an arbitrary number of lines. I highly suggest getting
Learning Perl
And/Or
The Camel Book
If you are going to be doing any amount of Perl programming, both are very useful. Of course there are lots of online tutorials, too.

                - Ant
                - Some of my best work - (1 2 3)

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (6)
As of 2016-07-31 08:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What is your favorite alternate name for a (specific) keyboard key?


















    Results (269 votes). Check out past polls.