Here's my query.
for($i=1;$i<=$count;$i++){
my $man = $list[$i];
my $week = 1;
#run query to get players picks for the week.
my $sqlstatement = q{SELECT pick from Picks WHERE week= ? and player= ?};
my $sth = $dbh->prepare($sqlstatement);
$sth->execute($week,$man) ||
die "Could not execute SQL statement ... maybe invalid?";
}
Here's my Errror message:
DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver] Too
few
parameters. Expected 3. (SQL-07001)(DBD: st_execute/SQLExecute err=-1) at
report
sa.pl line 73.
Could not execute SQL statement ... maybe invalid? at reportsa.pl line 73.
What up?
