in reply to Re^2: DBI place holder for sub query problem
in thread DBI place holder for sub query problem

If you are using a sub-query then the parenthesis are needed. Just omit the single quotes.
$sth=$dbh->prepare("Update Customers set RESULTS = (?) where rec_no = +?");
From the error message, it seems like you are assigning RESULTS with something like SELECT.