Re^3: Global symbol "$prepare" requires explicit package name

In addition to what poj said, instead of

$sth2 = $dbh->prepare("update $what$ever");
[download]

to see what's going on, write

my $sqltext = "update $what$ever";
print qq(SQL query is: "$sqltext");
$sth2 = $dbh->prepare($sqltext);
[download]

Perhaps there's a stray question mark in your $date_new

Comment on Re^3: Global symbol "$prepare" requires explicit package name Select or Download Code

Replies are listed 'Best First'.
Re^4: Global symbol "$prepare" requires explicit package name by tukusejssirs (Beadle) on Sep 19, 2019 at 08:09 UTC
Indeed poj, it works now. Could you tell me please, why does it need to have `?` (I believe these question marks are those placeholders from the error message) in the `prepare` part? And why I could not run `$dbh->execute("update $schema.$table set $date_col = $date_new where $where_col = 1;") or die;` directly? In this particular code I don’t need neither `$sth` handle for reuse nor the placeholders to re-execute the code (as the variables will be all the same in all the loop cycles).<\p> Thank you very much!	[reply] [d/l] [select]
Re^5: Global symbol "$prepare" requires explicit package name by hippo (Bishop) on Sep 19, 2019 at 09:05 UTC
I don’t need neither $sth handle for reuse nor the placeholders to re-execute the code Placeholders are not just beneficial for handle re-use. See eg. Re: What are placeholders in DBI, and why would I want to use them? and the related allusions in Databases made easy. Perhaps your data would otherwise have been incorrectly quoted or incorrectly escaped or be of the wrong type or be in an inadmissible format, etc. Use placeholders or be prepared to explain and justify precisely why you have chosen not to.	[reply]
Re^5: Global symbol "$prepare" requires explicit package name by soonix (Canon) on Sep 19, 2019 at 10:44 UTC
What you're asking for, here, is do.	[reply]


Clear questions and runnable code get the best and fastest answer
	PerlMonks