ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Zurke <mis...@zurke.info>
Subject Re: dynamic update -> comma prob
Date Thu, 09 Jun 2005 16:51:32 GMT
ok, but what if name is not available and othername is?

Brandon Goodin wrote:
> <update id="update" parameterClass="java.util.Map">
>       UPDATE public.master
>       SET
>       <isPropertyAvailable property="name">
>        name        = #name#
>       </isPropertyAvailable>
>       <isPropertyAvailable prepend="," property="othername">
>                othername   = #othername#
>       </isPropertyAvailable>
>         WHERE id = #id#
>     </update>
> 
> On 6/9/05, Michael Zurke <mischa@zurke.info> wrote:
> 
>>hi,
>>
>>i got the following statement:
>>
>><update id="update" parameterClass="java.util.Map">
>>       UPDATE public.master
>>       SET
>>       <isPropertyAvailable property="name">
>>        name        = #name#,
>>       </isPropertyAvailable>
>>       <isPropertyAvailable property="othername">
>>                othername   = #othername#
>>       </isPropertyAvailable>
>>         WHERE id = #id#
>>     </update>
>>
>>Now is there an easy way to get rid of the comma after #name# in case
>>that the property "othername# is not available? or do i have to check
>>if "othername" is set before setting the name field. for this example it
>>would be kind of ok but let's assume i do the same for lots of fields...err.
>>
>>any ideas?
>>
>>thanx,
>>mish
>>
> 
> 


Mime
View raw message