syntax error in SQL Insert Statement

Ads
 

syntax error in SQL Insert Statement

Dear Sir ,I have write following code to save data into access databse,
but code gives following error
code:
PreparedStatement stm1=con.prepareStatement("insert into newfresher(prn,date)values(?,?)");

Error:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
INSERT INTO statement.
plz Help Me
View Answers

April 10, 2010 at 11:37 AM

Hi Friend,

Please post your code.

Thanks

Ads









Related Tutorials/Questions & Answers:
sql syntax error help
sql syntax error help  this query show syntax error .. i am unable to figure it out insert into order (orderdate, dpname, paymethod, tamount...') where is the error ?   Please send the error details and the datatype
error : not an sql expression statement
error : not an sql expression statement  hii I am gettin followin error in connecting to database SQLserver 2005 in Jdeveloper,i m usin struts... { Connection conn = DatabaseManager.getConnection(); Statement stmt
Advertisements
oracle insert statement error - JDBC
oracle insert statement error  hi.. please help me to insert a image into oracle 11g database and please say me how can i insert image from directory like G:\imagefolder\ultrasoundimage\02us02.jpeg please help me
The INSERT INTO Statement, SQL Tutorial
The INSERT INTO Statement       The INSERT INTO statement is used to insert or add a record... values then we should use the following SQL statement
PHP SQL Insert Statement
PHP SQL Insert Statement       PHP SQL Insert Statement show you the message when the records... The Tutorial illustrate an example from 'PHP SQL Insert Statement'. To understand
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.  String sql = "UPDATE emp_details SET empEname... = ?"; PreparedStatement pst = connection.prepareStatement(sql); pst.setString
to write an SQL query using insert statement
to write an SQL query using insert statement  I need to write an sql query for the below using InSERT command.pls help. Insert 5-star ratings by James Cameron for all movies in the database. Leave the review date as NULL
JDBC Batch Example With SQL Insert Statement
JDBC Batch Example With SQL Insert Statement: In this tutorial, we are discuss about insert SQL statement with the jdbc batch. First of all, we... SQL insert statement for save data in the datasource and add
SQL And Statement
SQL AND Statement      ... with Example The Tutorial illustrates an example from SQL AND Statement... AND Operator Syntax The SQL AND Operator Syntax  return you a filter
ERROR 601 (42P00): Syntax error. Encountered
ERROR 601 (42P00): Syntax error. Encountered   Hi, In HBase program I am executing the insert into query, but it is giving following error: ERROR 601 (42P00): Syntax error. Encountered "insert" at line 1, column 1. How
Syntax error in my UPDATE..please advise
Syntax error in my UPDATE..please advise  Hi experts, I tested my... in your SQL syntax; check the manual that corresponds to your MySQL server version...) And here's my UPDATE Statement: String sql = "UPDATE members SET strNRICNO
SQL SELECT DISTINCT Statement
or rows into table 'Stu_Table'. SQL statement to insert data into table... SQL SELECT DISTINCT Statement     ... with the select statement. The SQL Distinct clause is used with the Select statement
SQL Avg Syntax
SQL Avg Syntax       SQL Avg Syntax is used to compute the average of the records in a table. Understand with Example The Tutorial illustrate an example from 'SQL Average Syntax
Jdbc Insert Statement
JDBC Insert Statement       Add a row to a existing table using insert statement in JDBC. The tutorial illustrates an example from JDBC Insert Statement. In this program
JDBC Prepared Statement Insert
JDBC Prepared Statement Insert   ... Statement Insert. In this Tutorial  the code describe the include a class... the given below code, we declare String variable sql,that is used to hold the insert
error
error  I am running a program insert into statement in sql using.../ServletUserEnquiryForm.shtml getting an error given below SQLException caught: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error please suggest
SQL Alter Column Syntax
SQL Alter Column Syntax       SQL Alter Column Syntax modifies the existing table definition. Understand with Example The Tutorial illustrate an example from SQL Alter Column Syntax
SQL Alter Table Syntax
SQL Alter Table Syntax       SQL Alter Table Syntax modifies the existing table definition. Understand with Example The Tutorial illustrate an example from SQL
SQL QUERY ERROR
SQL QUERY ERROR  Im writing a query which shows error of INVALID CHARACTER The Query is Insert into PMST_EMP_MST(PMSNUM_EMP_ID,PMSSTR_EMP... IN THE DATABASE. PLEASE HELP ME.  Syntax of insert query is: INSERT
ModuleNotFoundError: No module named 'sql-insert-writer'
named 'sql-insert-writer' error? Thanks   Hi, In your...: No module named 'sql-insert-writer' error will be solved. Thanks...ModuleNotFoundError: No module named 'sql-insert-writer'  Hi, My
Select Statement in SQL, SQL Tutorial
The SELECT statement for SQL       SELECT key word is used to select data from a table.  Syntax:           SELECT column_name(s
SQL Error Version 5.5.15
SQL Error Version 5.5.15  SQL Error Version 5.5.15
SQL Backup query with where statement
SQL Backup query with where statement       SQL Backup query with where statement ...()); Insert Data Into Stu_Table Insert into statement add the records
Create After Insert Trigger in SQL
Create After Insert Trigger in SQL   ... from 'Create After Insert Trigger in SQL'. In this Example, we create... inside the begin-end statement. The insert into add the records or rows value
SQL Bulk Insert Example
SQL Bulk Insert Example       SQL Bulk Insert Example is used to insert a bulk record... to create SQL Bulk Insert .To grasp this example we create a table 'Stu
Need SQL Statement
IS THE SQL STATEMENT NEEDED TO ACHIEVE THESE RESULTS...Need SQL Statement  QUESTION IS CAPITALIZED AT THE BOTTOM... There is a table Employee, with three columns: Name (varchar), Department (varchar
correct the sql error
correct the sql error  i am getting a SQL Error while retriving data...(null,"Please enter the Student ID to Search","Error",0); } else { try...:odbc:college"); Statement st=con.createStatement
JSP SQL Error
JSP SQL Error  Hi While trying to execute the below code i'm getting the following error "java.sql.SQLException: Io exception: Got minus one from...:oracle:thin:@localhost:8084:dsn","system","tiger"); Statement st=null
SQL Bulk Insert Example
SQL Bulk Insert Example       SQL Bulk Insert Example is used to insert a bulk record to the table. Understand with Example The Tutorial illustrate an Example to create SQL
The UPDATE Statement, SQL Tutorial
a specified criteria. In the given syntax of update statement the keyword SET... statement : Syntax: UPDATE 'table_name' SET 'field_name... The UPDATE Statement      
SQL SELECT DISTINCT Statement
the records or rows into table 'Stu_Table'. SQL statement to insert data... SQL SELECT DISTINCT Statement   ... clause with the select statement. The SQL Distinct clause is used with the Select

Ads