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]
