mapped-statement update

============================================= -->

<dynamic-mapped-statement name=??updateattachmentDao?? >

update ATTACHMENT

<dynamic prepend=??set??>

<isPropertyAvailable prepend=??,?? property=??ATTACHID?? >

ATTACHID=#ATTACHID#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHFILENAME?? >

ATTACHFILENAME=#ATTACHFILENAME:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHFILEPATH?? >

ATTACHFILEPATH=#ATTACHFILEPATH:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHFILESIZE?? >

ATTACHFILESIZE=#ATTACHFILESIZE#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHMIMETYPE?? >

ATTACHMIMETYPE=#ATTACHMIMETYPE:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHDESC?? >

ATTACHDESC=#ATTACHDESC:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHCREATIONIP?? >

ATTACHCREATIONIP=#ATTACHCREATIONIP:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHCREATIONDATE?? >

ATTACHCREATIONDATE=#ATTACHCREATIONDATE#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHMODIFIEDDATE?? >

ATTACHMODIFIEDDATE=#ATTACHMODIFIEDDATE#

</isPropertyAvailable>

</dynamic>

<dynamic prepend=??where??>

<isPropertyAvailable prepend=??and?? property=??ATTACHID?? >

ATTACHID=#ATTACHID#

</isPropertyAvailable>

<isPropertyAvailable prepend=??and?? property=??ATTACHFILENAME?? >

ATTACHFILENAME=#ATTACHFILENAME:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??and?? property=??ATTACHFILEPATH?? >

ATTACHFILEPATH=#ATTACHFILEPATH:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??and?? property=??ATTACHFILESIZE?? >

ATTACHFILESIZE=#ATTACHFILESIZE#

</isPropertyAvailable>

<isPropertyAvailable prepend=??and?? property=??ATTACHMIMETYPE?? >

ATTACHMIMETYPE=#ATTACHMIMETYPE:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??and?? property=??ATTACHDESC?? >

ATTACHDESC=#ATTACHDESC:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??and?? property=??ATTACHCREATIONIP?? >

ATTACHCREATIONIP=#ATTACHCREATIONIP:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??and?? property=??ATTACHCREATIONDATE?? >

ATTACHCREATIONDATE=#ATTACHCREATIONDATE#

</isPropertyAvailable>

<isPropertyAvailable prepend=??and?? property=??ATTACHMODIFIEDDATE?? >

ATTACHMODIFIEDDATE=#ATTACHMODIFIEDDATE#

</isPropertyAvailable>

</dynamic>

</dynamic-mapped-statement>

mapped-statement updateByPrimaryKey

============================================= -->

<dynamic-mapped-statement name=??updateByPrimaryKeyattachmentDao?? >

update ATTACHMENT

<dynamic prepend=??set??>

<isPropertyAvailable prepend=??,?? property=??ATTACHID?? >

ATTACHID=#ATTACHID#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHFILENAME?? >

ATTACHFILENAME=#ATTACHFILENAME:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHFILEPATH?? >

ATTACHFILEPATH=#ATTACHFILEPATH:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHFILESIZE?? >

ATTACHFILESIZE=#ATTACHFILESIZE#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHMIMETYPE?? >

ATTACHMIMETYPE=#ATTACHMIMETYPE:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHDESC?? >

ATTACHDESC=#ATTACHDESC:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHCREATIONIP?? >

ATTACHCREATIONIP=#ATTACHCREATIONIP:VARCHAR#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHCREATIONDATE?? >

ATTACHCREATIONDATE=#ATTACHCREATIONDATE#

</isPropertyAvailable>

<isPropertyAvailable prepend=??,?? property=??ATTACHMODIFIEDDATE?? >

ATTACHMODIFIEDDATE=#ATTACHMODIFIEDDATE#

</isPropertyAvailable>

</dynamic>

<dynamic prepend=??where??>

<isPropertyAvailable prepend=??and?? property=??ATTACHID?? >

ATTACHID=#ATTACHID#

</isPropertyAvailable>

</dynamic>

</dynamic-mapped-statement>