in reply to Pipe tag being entered into database
You should use placeholders when prepare()ing a DB insertion. Try this:
my $sql = qq{INSERT INTO $dbtable VALUES(GFMIS.FIXCUSTOMERPERF_SEQ.nex +tval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}; my $sth = $dbh->prepare($sql); $sth->execute($recclient, $recordid, $senddborderid, # ... (and so on for the rest of your variables) );
This is cleaner, usually more efficient and also avoids lots of quoting issues. (Note, this is probably not the cause of your problem, as holli explains above, but could save you grief in the future.)
|
|---|