-----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
