Update question

From: Jerry Preston <g-preston1_at_ti.com>
Date: Fri, 05 Nov 1999 10:30:23 -0600
Message-ID: <3823061F.C832159F@ti.com>

Hi, I am using Perl/CGI. Insert and Delete work fine, but I cannot get Update to work:

my $sql="insert into twroot.SCRAP_STATUS( WAFER_ID, TP_MP, BOAT, SLOT, SCRAPPED_BY, SCRAPPED_NAME, SCRAPPED_DATE ) values( ?, ?, ?, ?, ?, ?, ? ) ";

my $sth = $dbh->prepare( "delete from twroot.SCRAP_STATUS where WAFER_ID = '$j' " );

my $sql="update twroot.SCRAP_STATUS( REMOVED_BY, REMOVED_NAME, REMOVED_REASON, REMOVED_DATE ) What am I doing wrong? Any ideas?

Thanks,

Jerry Received on Fri Nov 05 1999 - 10:30:23 CST