Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL insert query

 
shuzo monsoon
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Marshal
Pie
Posts: 65339
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to the JDBC Forum.
 
eammon bannon
Ranch Hand
Posts: 140
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic