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

[Anonymous Monk]

Thanks for the input. In the sample code I posted I am not calling any database handler - yet. I just want to display the sql for now that I am pulling from a hash. So where would the placeholder go in that code?

[runrig]

E.g., instead of:

WHERE asof_date = '$test_date'

do:

WHERE asof_date = ?

and when you execute the sql statement:

$sth->execute($test_date);

[tapolyaip]

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.

[Anonymous Monk]

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