Hi all guys, sorry but I explained my "2 cents idea" in the wrong way :P Indeed, in my dreams, I'd completely _remove_ the #{} syntax, IMHO it should be simpler reading a 100% pure XML SQL map like:
update ORDER_ENTRY.CONTACT set DEPT_ID = <parameter name="deptId" javaType="String" jdbcType="VARCHAR" /> STATE_ID = <parameter name="stateId" javaType="String" jdbcType="VARCHAR" /> TIME_ZONE_ID = <parameter name="timeZoneId" javaType="String" jdbcType="VARCHAR" /> instead of update ORDER_ENTRY.CONTACT set DEPT_ID = #{deptId, javaType=String, jdbcType=VARCHAR}, STATE_ID = #{stateId, javaType=String, jdbcType=VARCHAR}, TIME_ZONE_ID = #{timeZoneId, javaType=String, jdbcType=VARCHAR} even if, of course, for a simpler case like: insert into users ( id, username, password) values ( <parameter name="id"/>, <parameter name="username"/>, <parameter name="password"/> ) is much more verbose than: insert into users ( id, username, password) values ( #{id}, #{username}, #{password} ) Thoughts? All the best, Simo http://people.apache.org/~simonetripodi/ On Thu, Feb 4, 2010 at 2:20 AM, Daryl Stultz <da...@6degrees.com> wrote: > > On Wed, Feb 3, 2010 at 7:38 PM, Guy Rouillier <guyr-...@burntmail.com> > wrote: >> >> On 2/3/2010 3:54 PM, Daryl Stultz wrote: > > >>> >>> I like this idea, though to keep things consistent, I would just use >>> "parameter" instead of "parameterDef". > > Right, I just made up parameterDef to indicate is was for defining the > parameter rather than using it. I'm pretty new to iBATIS, so I haven't used > <parameter> yet and didn't want to suggest an orthogonal usage of it. > -- > Daryl Stultz > _____________________________________ > 6 Degrees Software and Consulting, Inc. > http://www.6degrees.com > mailto:da...@6degrees.com > --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org