Re: dynamic update -> comma prob

[Michael Zurke]

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