hello, I have redhat 7.1 and perl is loaded with mysql , I have several scripts with perl , DBI, DBD and mysql working fine , so If think I have everything set up properly
But I get an error : DBD::mysql::st execute failed: Duplicate entry '204' for key 1 at /var/www/cgi-b in/sobt/chstatus2.cgi line 107. unable to execute query at /var/www/cgi-bin/sobt/chstatus2.cgi line 107. Issuing rollback() for database handle being DESTROY'd without explicit disconnect(). this is the section of code ( with line numbers) 97 $dbh2 =DBI ->connect($data_source, $username, $password); 98 my $sth2 = $dbh2 -> prepare("select title from media1 where num ='$nu m'"); 99 100 $sth2 -> execute or die " unable to execute query "; 101 102 103 $dbh2 =DBI ->connect($data_source, $username, $password); 104 my $sth2 = $dbh2 -> prepare("insert into history(num,title,date,user1 )values('$num','$date1','$date1','$name')"); 105 106 107 $sth2 -> execute or die " unable to execute query "; 108 109 110 Help Thanks Jim F -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]