You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Gilles Bayon (JIRA)" <ib...@incubator.apache.org> on 2008/05/31 15:55:46 UTC
[jira] Closed: (IBATISNET-267) Support inline paramaters and
dynamic element in procedure tag
[ https://issues.apache.org/jira/browse/IBATISNET-267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gilles Bayon closed IBATISNET-267.
----------------------------------
Resolution: Fixed
in SVN
> Support inline paramaters and dynamic element in procedure tag
> --------------------------------------------------------------
>
> Key: IBATISNET-267
> URL: https://issues.apache.org/jira/browse/IBATISNET-267
> Project: iBatis for .NET
> Issue Type: Improvement
> Components: DataMapper
> Affects Versions: DataMapper 3.0
> Reporter: Gilles Bayon
> Assignee: Gilles Bayon
> Fix For: DataMapper 3.0
>
>
> Samples
> ========
> <procedure id="SPWithInlineParameter" parameterClass="int" resultClass="Account">
> ps_SelectAccount @{Account_ID,column=Account_ID}
> </procedure>
> <procedure id="SPWithInlineParameterAndOutPutParam" parameterClass="map" resultClass="Account">
> ps_SelectAccountWithOutPutParam @{Account_ID,column=Account_ID}, @{OutPut,column=OutPut}
> </procedure>
> <procedure id="InsertAccountViaSPAndInlineParameter" parameterClass="map" >
> ps_InsertAccount
> @{Id,column=Account_ID},
> @{FirstName,column=Account_FirstName},
> @{LastName,column=Account_LastName},
> @{EmailAddress,column=Account_Email,nullValue=no_email@provided.com},
> @{BannerOption,column=Account_Banner_Option,dbType=Varchar,type=bool},
> @{CartOption,column=Account_Cart_Option,handler=HundredsBool}
> </procedure>
> <procedure id="InsertAccountViaSPWithDefaultParameter" parameterClass="map" >
> ps_InsertAccountWithDefault
> @{Id,column=Account_ID},
> @{FirstName,column=Account_FirstName},
> @{LastName,column=Account_LastName},
> @{EmailAddress,column=Account_Email,nullValue=no_email@provided.com}
> </procedure>
> <procedure id="InsertAccountViaSPWithDynamicParameter" parameterClass="map" >
> ps_InsertAccountWithDefault
> @{Id,column=Account_ID}
> ,@{FirstName,column=Account_FirstName}
> ,@{LastName,column=Account_LastName}
> ,@{EmailAddress,column=Account_Email,nullValue=no_email@provided.com}
> <isNotNull property="NullBannerOption">
> ,@{NullBannerOption,column=Account_Banner_Option,dbType=Varchar,type=bool}
> </isNotNull>
> @{CartOption,column=Account_Cart_Option,handler=HundredsBool}
> </procedure>
> Can be use in conjunction with procedure default parameter
> REATE PROCEDURE dbo.[ps_InsertAccountWithDefault]
> @Account_ID [int],
> @Account_FirstName [nvarchar](40),
> @Account_LastName [varchar](32),
> @Account_Email [varchar](128),
> @Account_Banner_Option [varchar](255)='Non',
> @Account_Cart_Option [int] =200
> AS
> ...
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.