my $Str = "Insert into City_Policies (ID, DATE_CREATED, ISSEDBY, SUBJECT) values ('$policynumber', '$DATE_CR', '$ISSUEDBY', '$newsubject')"; warn $Str; $dbh->do($Str) or print "I died"; #### my $POLICY1 = ""; my $DATE_CR = ""; my $POLICY2 = ""; my $POLICY3 = ""; my $POLICY4 = ""; my $POLICY5 = ""; my $POLICY6 = ""; my $ISSUEDBY = ""; my $SUBJECT =""; my $PURPOSE = ""; $POLICY1 =~s/
/\n/g; $POLICY2 =~s/
/\n/g; $POLICY3 =~s/
/\n/g; $POLICY4 =~s/
/\n/g; $POLICY5 =~s/
/\n/g; $POLICY6 =~s/
/\n/g; $POLICY1 =~s/
/\n/g; $POLICY2 =~s/
/\n/g; $POLICY3 =~s/
/\n/g; $POLICY4 =~s/
/\n/g; $POLICY5 =~s/
/\n/g; $POLICY6 =~s/
/\n/g; ##
## my ($IDNUM, $ISSUEDBY, $DATE_CR, $SUBJECT, $PURPOSE, $POLICY1, $POLICY2, $POLICY3, $POLICY4, $POLICY5, $POLICY6) = $sth->fetchrow_array; $_ ||= '' for ($DATE_CR, $ISSUEDBY, $SUBJECT, $PURPOSE); $_ ||= '', s/
/\n/ig for ($POLICY1, $POLICY2, $POLICY3, $POLICY4, $POLICY5, $POLICY6);