Thanks to all the responses! Rerecording the SQL statements into the
syncmaster is now working....HOWEVER, Executing them is not....the original
SQL statements are coming from an MSSQL Servers Sync table (which is where
@updates comes from...)
Here's what I am doing now:
#Prepare SQL Statement for Updateing SYNCMASTERS LIST And Destination Dbase
$sql="INSERT INTO syncrecords VALUES(?,?)";
$sth=$dbh->prepare($sql);
$sqld="?";
$sthd=$dbhd->prepare($sqld);
#### UPDATE SYNCMASTER And Destination######
for my $urow(@updates) {
# print "INSERT INTO syncrecords VALUES ($urow->[0],$urow->[1])\n";
$sth->execute($urow->[0],$urow->[1]);
$dbh->commit;
$success=$dbhd->do ("$urow->[1]");
print "\$success=$success\n";
print "DEBUG:\n CODE: do (\"\$urow->[1]\");\ngenerates:\n$urow->[1]\n BUT
does ABSOSMURFLY NOTHING!\n";
$dbhd->commit;
} #End of FOR for updating SYNCMASTER/UPDATES
$dbhd->commit;
print"finished\n\n";
#$sthd->finish();
$dbhd->disconnect();
} # end of Inner For Loop
$sths->finish();
$dbhs->disconnect();
}
$dbhs->disconnect();
$sth->finish();
$dbh->disconnect();
The problem now being that while $success equals 1 (or true I presume) no
errors are reported and no data ends up in the table. In looking at the docs
for ERROR trapping, I have yet to figure out how to trace what's actually
happening at this level, just on the CONNECTION level have I figured that out,
or by watching the Proxy Server in debug mode, which also indicates success on
these statements.
I suspect my problem lies in the fact that I'm actually giving the WHOLE SQL
statement as a variable, which cannot be helped in this case, I cannot think of
a way around this issue....especially since an UPDATE is a DELETE followed by
an INSERT and assumptions are that table and fieldnames are all
lowercase..which they are...so I can do a blind replica....
I have tried isolating one insert statement and issuing it in a similar
fashion with the same results, here is the output of program:
$success=1
DEBUG:
CODE: do ("$urow->[1]");
generates:
insert into synctest1 values(49,'test3',20,'1998-05-20 00:00:00','1')
BUT does ABSOSMURFLY NOTHING!
$success=1
DEBUG:
CODE: do ("$urow->[1]");
generates:
delete from synctest1 where synctestid = 49
BUT does ABSOSMURFLY NOTHING!
$success=1
DEBUG:
CODE: do ("$urow->[1]");
generates:
insert into synctest1 values (49,'test3',20,'1998-05-20 00:00:00','0')
BUT does ABSOSMURFLY NOTHING!
$success=1
DEBUG:
CODE: do ("$urow->[1]");
generates:
delete from synctest1 where synctestid = 49
BUT does ABSOSMURFLY NOTHING!
$success=1
DEBUG:
CODE: do ("$urow->[1]");
generates:
insert into synctest1 values(49,'test3',20,'1998-05-20 00:00:00','1')
BUT does ABSOSMURFLY NOTHING!
finished
--
Michael Wray
Network Administrator
FamilyConnect, Inc.
