ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: dynamic update -> comma prob
Date Thu, 09 Jun 2005 19:33:28 GMT
did you try it?

On 6/9/05, Michael Zurke <mischa@zurke.info> wrote:
> 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