SQL insert query

[shuzo monsoon]

Hello people! I'm experiencing difficulty in executing an INSERT query from a JSP page. The problem is with the WHERE part of the clause (because it works when I've taken it out) , I've tried two different versions - here they are:

String insertQuery = "UPDATE CUSTOMER SET(PaymentType, CardNumber, ExpiryDate, IssueNumber) = (['"+ newPayType +"', '"+ newCardNo +"','"+ expiryDate +"','"+ newIssueNo +"']) WHERE CustID LIKE '"+custId+"'";

Second variation

 
String insertQuery = "INSERT INTO CUSTOMER(PaymentType, CardNumber, ExpiryDate, IssueNumber) VALUES('"+ newPayType +"', '"+ newCardNo +"','"+ expiryDate +"','"+ newIssueNo +"') WHERE CustID = '"+custId+"'";

What I should say is that the table into which I am inserting already has some values in different fields and basically the rest of the fields in that row need to be filled.
Can anyone help? Thank you!
[ March 18, 2004: Message edited by: shuzo monsoon ]

[Bear Bibeault]

Moving to the JDBC Forum.

[eammon bannon]

Looks like you are confusing sql INSERT syntax with SQL UPDATE syntax. Your first update will probably work if you write it like this:

"UPDATE CUSTOMER SET PaymentType = '" + newPayType + "', CardNumber = '" + newCardNo + "', ExpiryDate = '" + expiryDate +"', IssueNumber = '" + newIssueNo +"' WHERE CustID LIKE '"+custId+"'";

[ March 18, 2004: Message edited by: eammon bannon ]