If I understand correctly, you would like to get the last auto_increment. Well, all you need to do is use the mysql function LAST_INSERT_ID() This doesn't really have to do with JSP's though. Good luck, hope this helps.
-Marc Benstein >From: Papo Napolitano <[EMAIL PROTECTED]> >Reply-To: A mailing list about Java Server Pages specification and >reference <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: jsp-mysql auto_increment >Date: Mon, 26 Nov 2001 19:24:38 -0300 > >Hi! > >I've a mysql table with an auto_increment field.... so.. > >How can I, after having inserted the results get back in the application >the >id >of the experiment ? I may not do a select max afterward since this >application >is being used by quite a lot of people concurrently > >cheers, > >Papo > >=========================================================================== >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff >JSP-INTEREST". >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST >DIGEST". >Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
