Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of jeffgbutler@gmail.com
 designates 209.85.160.57 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=NqPkQZsM+n5+cfCv5V7FTBsSnPtN3ik31xVhEQpTobjSB11EhYVhg1Ti4AVxlJtnGN
         qUh7JMzIX2HcGX3jV2PZxnSrc+RM0FsbXtx7iwtS5Zr26+SQPtjSl+HAmtvB/13qJJ/i
         YXRIamI7dpxx8LR1Xy0vEnFtjes+pIPwV1N3c=
MIME-Version: 1.0
In-Reply-To: <6892C825A8016D4681D01CF07391E452C45679@PE-EVS.converge.com>
References: <c593b8750910221229u51a8de82g3c9674f8d2c43699@mail.gmail.com>
	 <6892C825A8016D4681D01CF07391E452C45679@PE-EVS.converge.com>
Date: Thu, 22 Oct 2009 14:34:57 -0500
Message-ID: <c593b8750910221234p458e4d22k1f769711c88f3b12@mail.gmail.com>
Subject: Re: Update Table with selected columns
From: Jeff Butler <jeffgbutler@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

updateByPrimaryKeySelective and updateByExampleSelective allow you to
select the columns - only non-null columns in the parameter objects
will be updated.

Jeff Butler


On Thu, Oct 22, 2009 at 2:31 PM, Vinaya Tirikkovalluru
<vinaya.tirikkovalluru@converge.com> wrote:
> They do, they don't take the specified columns though.
> I need to update all the columns in the table.
> I don't want to do that. I would like to specify which columns I want to
> update, not all
>
> Thanks
> Vinaya
>
>
>
>
> -----Original Message-----
> From: Jeff Butler [mailto:jeffgbutler@gmail.com]
> Sent: Thursday, October 22, 2009 3:29 PM
> To: user-java@ibatis.apache.org
> Subject: Re: Update Table with selected columns
>
> Ibator generates updateByPrimaryKey and updateByExample methods that
> serve this purpose.
>
> Jeff Butler
>
>
> On Thu, Oct 22, 2009 at 2:26 PM, Vinaya Tirikkovalluru
> <vinaya.tirikkovalluru@converge.com> wrote:
>> Hi,
>>
>>
>>
>> I am using Ibator to generate the Ibatis objects.
>>
>> I have a requirement where I should be able to create the SQL as
>>
>>
>>
>> Update table set a=3D1, b=3D2, c=3D3, .... Where clause/primary key
>>
>>
>>
>> Any one did get this to work with Ibator? I would like to modify the
> Ibator
>> code if necessary
>>
>>
>>
>> Thanks
>>
>> Vinaya
>>
>>
>>
>> ________________________________
>> This electronic message is intended only for the use of the
> individual(s) or
>> entity(ies) named above and may contain information which is
> privileged
>> and/or confidential. If you are not the intended recipient, be aware
> that
>> any disclosure, copying, distribution, dissemination or use of the
> contents
>> of this message is prohibited. If you received this message in error,
> please
>> notify the sender immediately.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
>
> This electronic message is intended only for the use of the individual(s)=
 or entity(ies) named above and may contain information which is privileged=
 and/or confidential. =A0If you are not the intended recipient, be aware th=
at any disclosure, copying, distribution, dissemination or use of the conte=
nts of this message is prohibited. =A0If you received this message in error=
, please notify the sender immediately.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org