print "\n\t\tdo you want to write out the table (Y/N) "; my $ans = (); if ($ans =~ /y/i) { # say "\n\t\tDeleting Current Week: $weeknumber from Server Patch table"; my $sql = qq(DELETE FROM WFSServer_Patch WHERE weeknum = $weeknumber); my $rows = $dbh->do($sql); say "\n\t\tWriting Server Patch Table"; my $sth = $dbh->prepare(<execute($weeknumber, $server, $desc) or die "can't execute statement: $DBI::errstr\n"; } } }