ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Re: dynamic update -> comma prob
Date Thu, 09 Jun 2005 16:43:32 GMT
<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