Hi,
I'm trying to do a database fetch on one table, and an insert on another
table on the same DB. This looks like this:
$mssth=$msdbh->prepare("SELECT * FROM SyncroTess_in");
if ($mssth->execute) {
while (my @getdata=$mssth->fetchrow_array) {
.....
......
$msdbh->do("INSERT INTO SyncroTess_out Pakete, Ladestelle, AKNr,
time VALUES ('$einzelpaket','$ladestelle','$aknr','$now'");
....
....
and I get this error:
Tue Nov 20 14:55:51 2007 DBD::ODBC::db do failed: [Microsoft][ODBC SQL
Server Driver]Die Verbindung ist mit Ergebnissen von einem anderen hstmt
belegt (SQL-HY000)(DBD: Execute immediate failed err=-1) at soappush.pl
line 35.
(i.e. handle is in use)
how can I workaround this?
Lars
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
