did you try it?
On 6/9/05, Michael Zurke <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 > >> > > > > > >
