|
while
my predecessor didn't grok the difference between $delimiter$ & #delimiter#,
he did come up with exactly what u r looking 4:
<sqlmap>
<resultmap id='parameter'
class='my.param.obj'>
<result
property='id' column='id'>
<result property='date'
column='date'> <result property='name'
column='name'> <result property='value'
column='value'> </resultmap>
<update id='updateParam'
parameterClass='my.param.obj'>
UPDATE paramTable SET
<dynamic>
<isNotNull prepend=","
property="name">
name = $name$
</isNotNull>
<isNotNull prepend=","
property="date">
date = $date$
</isNotNull>
<isNotNull prepend=","
property="value">
value= $value$
</isNotNull>
</dynamic>
WHERE id = $id$
</update>
when
i've added columns, i've had to use the # delimiter, but the above works just
fine 4
me;-) |
- RE: Selective Update of fields depending on values in obje... Wible, Thomas E
