THANKS. IT Works!!! Using "placeholders" solved the problem. I will take this knowledge with me and move forward.
My head feels much better thanks to all. - Tony :) -----Original Message----- From: Moon, John [mailto:[EMAIL PROTECTED] Sent: Thursday, November 29, 2007 11:57 AM To: [email protected] Subject: RE: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my pain? -----Original Message----- From: BAIER, ANTHONY (TONY), ATTSI [mailto:[EMAIL PROTECTED] Sent: Thursday, November 29, 2007 11:06 AM To: STILWELL, DAVID B (DAVE), ATTLABS; [email protected] Subject: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my pain? Dave, DBI User Group, [>>] ... Issuing rollback() for database handle being DESTROY'd without explicit disconn ct(), <REPORTFILE> line 319. [>>] Well right off hand I don't see it but can suggest (from past experience!) that you use placeholders ... or at the least change the quote style... qq{insert ... some quoted '$string'}... The placeholders made my life much easier... Example... $sql = 'insert ... values (?,?,?,?,?)' ... $sth = $dbh->prepare($sql) or die DBI->errstr; $rc = $sth->execute($reportId, $queryNumber,$readCount, $execCount, $queryText); Hope this gives you some ideas... jwm
