Pleeaassee read the placeholders docs. You can't use a place holder in
place of the whole query. Placeholder are used for values, for example...
"insert into table_1 values (?, 1, ?)"
"select foo1, foo2 from bar where col1 = ?"
etc....
Place holders can't even be used to substitute table nor column names.
perldoc DBI and perldoc DBD::Pg are your friends.
Ilya Sterin
-----Original Message-----
From: Michael Wray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 7:58 PM
To: [EMAIL PROTECTED]
Subject: In Need of a Miracle...WAS:Re: Pg Connection WOES on DEADLINE!
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.
