Re: Storing a variable in a file and processing within the script

Summary of Problem: You are not converting the text in the script.

Just add one line to your processing loop (this is untested but should get the idea across):

{   
    print "$line \n";    
    $sql = $readline;
    $sql =~ s/\$table\_name/$table_name/g;
    executeSQL();
}
[download]

Comment on Re: Storing a variable in a file and processing within the script Download Code

Replies are listed 'Best First'.
Re^2: Storing a variable in a file and processing within the script by tony@perlmonks.org (Initiate) on Jul 17, 2013 at 16:12 UTC
This worked, Thanks for that..	[reply]
Re^3: Storing a variable in a file and processing within the script by Preceptor (Deacon) on Jul 17, 2013 at 17:01 UTC
Works nicely, but bear in mind that that is essentially a placeholder - that 's/...' line is replacing the text '$table_name' with the value held in the variable '$table_name'. I'd tend to suggest that's a source of confusion later on.	[reply]
Re^4: Storing a variable in a file and processing within the script by marinersk (Priest) on Jul 18, 2013 at 22:21 UTC
I absolutely agree -- scope confusion waiting to happen. I also fully agree with the other posters who added the suggestion to use clearly identifiable tags (I'm a big fan of double hash sign encapsulated codes like `##TABLE_NAME##` and such), as well as the numerous warnings about this solution being susceptible to injection attacks. I just figured the first step was to get the OP past the operational issue, and then start layering in the good engineering practices LOL.	[reply]
Re^4: Storing a variable in a file and processing within the script by tony@perlmonks.org (Initiate) on Jul 19, 2013 at 11:00 UTC
Noted. Thanks again	[reply]