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

E.g., instead of:

WHERE asof_date = '$test_date'
[download]

do:

WHERE asof_date = ?
[download]

and when you execute the sql statement:

$sth->execute($test_date);
[download]

Comment on Re^3: Variable interpolation in a file to be read in Select or Download Code

Replies are listed 'Best First'.
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.	[reply]
Re^5: Variable interpolation in a file to be read in by Anonymous Monk on Oct 07, 2011 at 02:42 UTC
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	[reply]


Come for the quick hacks, stay for the epiphanies.
	PerlMonks