Hi
Use placeholders
Verify operations
( 02.07.09 06:40 -0700 ) Dana Lucent:
> $datafile = "CERT.TXT";
> open(DATAFILE, $datafile);
Should check for errors here.
> chomp(@cert = <DATAFILE>);
Check @cert. I'm not sure you're using chomp correctly here [maybe].
Use and execute with variables later, for instance:
$sql = 'SELECT * FROM coverage_primary_loan ';
$sql .= 'WHERE certificate_number = ?';
Then put your $sth1 execute in a loop
foreach ( @cert ) {
$rv = $sth1->execute ( $_ );
# check $rv for error
}
Good luck!
--
\js
Yo! Ewige Blumenkraft, Dude!
