hello every one,
i m trying to insert data from jsp page to database using sql insert query. every thing is working fine but when i m using autonumber in database(Ms Access) it is showing error.
so please help me how to do it??/
pandeyprashant
0
Newbie Poster
Recommended Answers
Jump to PostExclude autonumber column from the list. I presume that the table TestTable has three columns; ID,Name,Age where column ID is autonumbered.
String sql="insert into TestTable (Name,Age) values ('A',20)";
Jump to PostThen there may be something wrong with your BD table as that query is just fine. Check this for example
All 8 Replies
kvprajapati
1,826
Posting Genius
Team Colleague
pandeyprashant
0
Newbie Poster
peter_budo
2,532
Code tags enforcer
Team Colleague
Featured Poster
kvprajapati
1,826
Posting Genius
Team Colleague
pandeyprashant
0
Newbie Poster
pandeyprashant
0
Newbie Poster
Thirusha
20
Posting Whiz
pandeyprashant
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.