Hmm that's not a bad idea for workaround :) should resolve my problem.
Thanks!
Juan Pablo Araya wrote:
>
> As far as I know you have two choices:
>
> 1. Set another property for Event class:
>
> Public IdInserted { get { return Identifier.Id; } set { Identifier.Id
> = value; } } -> null reference if Identifier is not instanced.
>
> 2. Create an insert procedure and pass the class for parameterMap,
> setting the type @proced_Id as output and mapp it to Identifier.Id.
>
> Greetings and sorry for my poor english!
>
> 2010/5/19 wekasalim <wekasa...@hotmail.com>:
>>
>> I'm using SQL Server 2008..
>>
>> Is there a way of not using the selectKey but instead the whole insert is
>> returning int like:
>>
>>> <insert id="InsertEvent" parameterClass="Event" resultClass="int">
>>> INSERT INTO nxEvent
>>> (Title, Time)
>>> VALUES
>>> (#Title#, #Time#)
>>> select @@IDENTITY as value
>>> </insert>
>>
>> Because setting it on the object is not important for me anyway..
>>
>> Thanks
>>
>>
>> Michael McCurrey-3 wrote:
>>>
>>> What DB platform are you running on?
>>>
>>>
>>> On Wed, May 19, 2010 at 4:15 PM, wekasalim <wekasa...@hotmail.com>
>>> wrote:
>>>
>>>>
>>>> Hi guys,
>>>>
>>>> I want to use selectKey to get the inserted id, however the property of
>>>> the
>>>> id on my class (Event) is actually an object as well. The name is
>>>> Identifier
>>>> and it has int property named Id. The following does not work:
>>>>
>>>> <insert id="InsertEvent" parameterClass="Event">
>>>> INSERT INTO nxEvent
>>>> (Title, Time)
>>>> VALUES
>>>> (#Title#, #Time#)
>>>> <selectKey resultClass="int" type="post" property="Identifier.Id"
>>>> >
>>>> select @@IDENTITY as value
>>>> </selectKey>
>>>> </insert>
>>>>
>>>> It says Event does not have Set member for 'Identifier.Id' Is there a
>>>> way
>>>> to
>>>> do this?
>>>>
>>>> Thanks,
>>>> Willy
>>>> --
>>>> View this message in context:
>>>> http://old.nabble.com/how-to-use-selectKey-where-property-is-an-object%E2%80%8F-tp28615389p28615389.html
>>>> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org
>>>> For additional commands, e-mail: user-cs-h...@ibatis.apache.org
>>>>
>>>>
>>>
>>>
>>> --
>>> Michael J. McCurrey
>>> Read with me at http://www.mccurrey.com
>>> http://chaoticmindramblings.blogspot.com/
>>>
>>>
>>
>> --
>> View this message in context:
>> http://old.nabble.com/how-to-use-selectKey-where-property-is-an-object%E2%80%8F-tp28615389p28616859.html
>> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org
>> For additional commands, e-mail: user-cs-h...@ibatis.apache.org
>>
>>
>
>
>
> --
> Juan Pablo Araya
> 787 76 034
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-cs-h...@ibatis.apache.org
>
>
>
--
View this message in context:
http://old.nabble.com/how-to-use-selectKey-where-property-is-an-object%E2%80%8F-tp28615389p28619748.html
Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-cs-h...@ibatis.apache.org
