Go4Expert

Go4Expert (http://www.go4expert.com/)
-   JSP (http://www.go4expert.com/forums/jsp/)
-   -   Insert-Retrieve Autonumber in Ms Access using JSP (http://www.go4expert.com/forums/insert-retrieve-autonumber-ms-access-t17857/)

sriram225 4Jun2009 17:50

Insert-Retrieve Autonumber in Ms Access using JSP
 
My Db SChema...
Quote:

ser_no : AUTONUMBER
name : TEXT

When i Insert a record how can i write my query ???
insert into table_name (ser_no,name) values('','jagadesh');
but this is not working....and after inserting succesfully i have to print AUTONUMBER (Retrieving) for correspoding record inserted !!??

Any Help Would be Greatly Appreciated Thank You!!!!

gkumar 25Jun2009 15:36

Re: Insert-Retrieve Autonumber in Ms Access using JSP
 
Please cut out that excessive use of dots, exclamation, question marks and Advertisement Like Words. You now look like an annoying little yelling child. Please don't do that. Please come over as a professional, try to ask questions the smart way.

With regard to your problem, use Statement#getGeneratedKeys().


All times are GMT +5.5. The time now is 03:51.