thanks, I know how to use selectKey and here i just want to return identity simply just now i have a way <statement id="Insert" parameterClass="string" resultClass="int"> INSERT INTO Table1 (Column1) VALUES (#value#) SELECT SCOPE_IDENTITY() </statement> it run ok.
2007/2/2, Clough, Samuel (USPC.PRG.Atlanta) <[EMAIL PROTECTED]>:
I believe select key is the tag you need to embed in your insert. Check the documentation, this is a very common scenario. ------------------------------ *From:* chook rib [mailto:[EMAIL PROTECTED] *Sent:* Thursday, February 01, 2007 9:12 AM *To:* [email protected] *Subject:* insert map run error <insert id="Insert" parameterClass="string" resultClass="int"> INSERT INTO Table1 (Column1) VALUES (#value#) SELECT SCOPE_IDENTITY() </insert> how to fix it to run right? thanks
