aspose file tools*
The moose likes JDBC and the fly likes an SQLException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "an SQLException" Watch "an SQLException" New topic
Author

an SQLException

bab javier
Ranch Hand

Joined: Aug 12, 2003
Posts: 32
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

Joined: Jan 10, 2002
Posts: 61437
    
  67

Moving this to the JDBC forum since the fact that this is being performed from a JSP is moot.
bear


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Nagendra Prasad
Ranch Hand

Joined: Jul 11, 2002
Posts: 219
It is to do with the '@' sign... you need to escape it properly.


Best Regards,<br />Nagendra Prasad.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: an SQLException