Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connecting to a database through servl

 
Roger Fed
Ranch Hand
Posts: 82
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've developed this servlet for dealing with a database

and this is the the code for HTML file

I've made a jdbc-odbc driver for my database and name it Address and use this driver to be able to deal with the database
but when i run this web application it give me a syntax error as follow:
Error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
why???

 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64683
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moved to the JDBC forum. Nothing to do with Servlets.
 
Paul Clapham
Sheriff
Pie
Posts: 20945
31
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My guess is that "E-mail" isn't a valid column name.
 
Raghu Chary
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can you give the table structure
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic