Re: Update question

A copy of this was sent to Jerry Preston <g-preston1_at_ti.com> (if that email address didn't require changing) On Fri, 05 Nov 1999 10:30:23 -0600, you wrote:

>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 )
>

that is not an update statement

it would be

update twroot.scrap_status

   set column_name = ?, column_name = ?, ....  where ....       

>What am I doing wrong? Any ideas?
>
>Thanks,
>
>Jerry

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Nov 05 1999 - 11:43:52 CST