Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^3: Variable interpolation in a file to be read in

by runrig (Abbot)
on Oct 06, 2011 at 17:45 UTC ( #930030=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Variable interpolation in a file to be read in
in thread Variable interpolation in a file to be read in

E.g., instead of:

WHERE asof_date = '$test_date'
do:
WHERE asof_date = ?
and when you execute the sql statement:
$sth->execute($test_date);


Comment on Re^3: Variable interpolation in a file to be read in
Select or Download Code
Re^4: Variable interpolation in a file to be read in
by tapolyaip (Initiate) on Oct 06, 2011 at 18:21 UTC

    Thanks for the very quick reply! The sqls, could hold the same variable ($test_date) multiple places because there are multiple dates in the table for various purposes. The sqls are not identical in the number of variables. Some have multiple $test_date some just one. Also the order the variables in the sqls could differ from one sql to the other, so a single set of $sth->execute($schema,$test_date) would not work.

    But in this case, forget about the sqls and the database connection. The sample code I submitted does not deal with the database. I just created a quick and dirty code because I was troubleshooting why my sqls errored out. Then I found out that the actual variables in the sqls don't interpolate the variable value, so I wrote up something quickly to pinpoint the issue - with no DB connection.

    So again, if I just read in a text file which have some perl variables, how can I have the text read in, take on the value of the variable that I defined in the program that reads in the text? - I guess is a better definition of the issue I am facing.

      So again, if I just read in a text file which have some perl variables, how can I have the text read in, take on the value of the variable that I defined in the program that reads in the text? - I guess is a better definition of the issue I am facing.

      Asked and answered, for interpolations use String::Interpolate::RE

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (7)
As of 2014-09-16 20:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (46 votes), past polls