my $fields = join(', ', @dbfields); my $places = join(', ', ('?') x @dbfields); my $insertrow = "INSERT into $table_webreporting ($fields) values ($places)"; $insertrow = $dbhc->prepare($insertrow);