• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

an SQLException

 
bab javier
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i'm using a JSP to INSERT to an MS Access DB. Problem is i get an exception:
javax.servlet.jsp.JspTagException: Error executing "
INSERT INTO UserDetails
VALUES(michelle, (String)
mich, (String)
marie,(String)
smith,(String)
35,(int)
tech_05@yahoo.com, (String)
1550)(String)
": java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'tech_05@yahoo.com'.
i don't understand the "missing operator" thing.
Also, when i deleted the value for the email address as well as the email field in the DB, i get this error "Too few parameters. Expected 4". I don't get it

thanks in advance guys!
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65229
95
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving this to the JDBC forum since the fact that this is being performed from a JSP is moot.
bear
 
Nagendra Prasad
Ranch Hand
Posts: 219
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It is to do with the '@' sign... you need to escape it properly.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic