<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
>
