Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

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

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

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (9)
As of 2016-10-25 19:29 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (327 votes). Check out past polls.