[ http://issues.apache.org/jira/browse/IBATIS-80?page=all ]
Brandon Goodin reassigned IBATIS-80:
------------------------------------
Assign To: Brandon Goodin
> dynamic statement when the parameterClass="string"
> --------------------------------------------------
>
> Key: IBATIS-80
> URL: http://issues.apache.org/jira/browse/IBATIS-80
> Project: iBatis for Java
> Type: Improvement
> Components: SQL Maps
> Versions: 2.0.9
> Environment: Windows XP
> jdk 1.5.0
> Reporter: Alexandru Barbat
> Assignee: Brandon Goodin
> Priority: Trivial
>
> (working) Example:
> <select id="customQuery" resultMap="custom-result" parameterClass="string">
> select CODE as VALUE, NAME as LABEL
> from SOME_TABLE
> where SOME_COLUMN=1
> and OTHER_COLUMN=#otherColumn#
> </select>
> (wish to work: example)
> <select id="customQuery" resultMap="custom-result" parameterClass="string">
> select CODE as VALUE, NAME as LABEL
> from SOME_TABLE
> where SOME_COLUMN=1
> <dynamic>
> <isNotEmpty prepend="and" property="otherColumn">
> OTHER_COLUMN=#otherColumn#
> </isNotEmpty>
> </dynamic>
> </select>
>
> I think it is natural (but it doesn't working).
> If the parameter has type : string, integer etc then any property (with any
> name) which appear in the statement to take the value from parameter.
> Please corect me if I'm wrong.
> Thank
> ps
> This improvement will cut down the cost when I have only one parameter .. I
> will not need a bean or a map to use the dynamic statements.
> xandu
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
