File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes SQL insert query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL insert query" Watch "SQL insert query" New topic

SQL insert query

shuzo monsoon
Ranch Hand

Joined: Feb 11, 2004
Posts: 54
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:

Second variation

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
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63868

Moving to the JDBC Forum.

[Asking smart questions] [About Bear] [Books by Bear]
eammon bannon
Ranch Hand

Joined: Mar 16, 2004
Posts: 140
Looks like you are confusing sql INSERT syntax with SQL UPDATE syntax. Your first update will probably work if you write it like this:

[ March 18, 2004: Message edited by: eammon bannon ]
I agree. Here's the link:
subject: SQL insert query
It's not a secret anymore!