I see using type="post", thanks. On Jan 2, 2008 6:02 PM, Justin Stanczak <[EMAIL PROTECTED]> wrote:
> Cool, how do you do that? > > > On Jan 2, 2008 5:59 PM, Nathan Maves <[EMAIL PROTECTED]> wrote: > > > This is correct with mysql. You can also specify the selectKey to be a > > "pre" or "post" then the placement of the code is not crucial. > > > > Nathan > > > > > > On Jan 2, 2008 3:54 PM, Justin Stanczak < [EMAIL PROTECTED]> wrote: > > > > > I'm currently using this to return the inserted objects generated key. > > > These are auto increment columns and I was wondering if this is correct. I > > > notice if I put the selectKey before the insert it returns the wrong key, > > > is > > > this correct? Just wanted to verify. > > > > > > <insert id="insertRole" parameterClass="Role"> > > > INSERT INTO SAVVYLMS.SVV_ROLE (SVV_NAME,SVV_TYPE_ID,SVV_DESC) VALUES > > > (#name#,#type#,#description#); > > > <selectKey keyProperty="id" resultClass="long"> > > > SELECT LAST_INSERT_ID(); > > > </selectKey> > > > </insert> > > > > > > -- > > > "All that is necessary for the triumph of evil is that good men do > > > nothing." Edmund Burke > > > > > > > > > -- > "All that is necessary for the triumph of evil is that good men do > nothing." Edmund Burke > -- "All that is necessary for the triumph of evil is that good men do nothing." Edmund Burke
