Problem with SQL 2005 insert statement using "sqlServer2.0" provider
--------------------------------------------------------------------
Key: IBATISNET-219
URL: https://issues.apache.org/jira/browse/IBATISNET-219
Project: iBatis for .NET
Issue Type: Bug
Components: DataMapper
Affects Versions: DataMapper 1.5.1
Environment: WinXP, SQL 2005, Visual Studio 2005 Team
Reporter: David Yeo
<select id="SelectAllInventory" resultMap="SelectAllResult">
SELECT Pid, PName, PDescription, QoH, UOM
FROM dbo.Inventory
Order By PName
</select>
<insert id="InsertItem" parameterClass ="Inventory">
INSERT INTO [Inventory]
([Pid], [PName], [PDescription], [QoH], [UOM])
VALUES
(#Pid#, #PName#, #PDescription#, #QoH#, #UoM#)
</insert>
The select statement worked with both "sqlServer2.0" and "OleDb2.0" provider.
but the insert statement worked only with "OleDb2.0" provider, when
"sqlServer2.0" provider is used the following error occurred:
The name "param0" is not permitted in this context. Valid expressions are
constants, constant expressions, and (in some contexts) variables. Column names
are not permitted.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
