Hi
Always use Single Quotes while using String objects in SQL statements
while dealing with MS Access . If u want u can see the method
getIdentifierQuoteString() in DatabaseMetaData interface of SQL package
which gives the Apt Quotes used by the DataBase
Thanks and Regards
L SRIDHAR REDDY
> -----Original Message-----
> From: Ram [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, January 25, 2000 10:09 AM
> To: [EMAIL PROTECTED]
> Subject: servlets and MS access: sql: "General error"
>
> Hi,
>
> I am urgently in need of help.
> I am trying to insert data into the table (MS Access) and I always get the
> erro "General error". I've spent 2 days trying to recover the SQL
> exception, but it doesn't work. I dont' know where is the mistake
>
> statement.executeUpdate("Insert into Sub (Login, TitleID) values ('" +
> Ulogin + "', " + STID + " )" );
>
> java.sql.SQLException: General error
>
> // with reference to the above statement
> I have tried using ResultSet xyz = statement.executeQuery("...");
>
> I also tried this........................ without variables. doesn't work.
> \|/
> statement.executeUpdate("Insert into Sub values ('" +
> Ulogin + "', " + STID + " )" );
>
> Ram
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
