Re: Obtaining SQL insert auto generated key from query within JSP
by Mark Space <markspace@[EMAIL PROTECTED]
>
Sep 11, 2008 at 11:51 AM
Damon Getsman wrote:
> Unfortunate, but that's the way it is. Anyway, I need to be able to
> determine the auto generated primary index field for the record that I
I'm guessing here but probably something like:
<sql:query>
select LAST_INSERT_ID();
</sql:query>
Do a search on that sql function, see what comes up. It's connection
oriented so I'm hoping the JSP will maintain an open connection for ya.