Good question. If you place the tags inside the <dynamic> tag, the first content producing dyanmic tag will have it's prepend removed. If you have further nested tags you can use the removeFirstPrepend attribute as well. Both of these are documented in the SQL Maps PDF.
Brandon 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 > >> > > > > > >
