Must declare the scalar variable
标签：
JavaScript
Server Error in '/Website1' Application.
Must declare the scalar variable "@Author".
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@Author".
Source Error:
Line 29: private void Data_Binding()Line 30: {Line 31: this.GvCycleCountFile.DataSource = objCycleCountFile.GetCycleCountFileByAuthor(InsusBase.SystemId); Line 32: this.GvCycleCountFile.DataBind();Line 33: } |
Source File: d:\IntranetSites\ERP\System\SyteLine\PhysicalTag\CycleCountSheet.aspx.cs Line: 31
Stack Trace:
[SqlException (0x80131904): Must declare the scalar variable "@Author".] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2030802 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009584 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275 System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33 System.Data.SqlClient.SqlDataReader.get_MetaData() +86 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +144 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +319 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94 Insus.NET.Base.ExecuteProcedure(String procedureName, DataSet& dataSet, SqlParameter[] prams) +189[Exception: Must declare the scalar variable "@Author".] Insus.NET.Base.ExecuteProcedure(String procedureName, DataSet& dataSet, SqlParameter[] prams) +253 Insus.NET.BusinessBase.GetDataToDataSet(String procedureName, Parameter[] sqlParameter) +326 Insus.NET.CycleCountFile.GetCycleCountFileByAuthor(String author) +88 System_SyteLine_PhysicalTag_CycleCountSheet.Data_Binding() in d:\IntranetSites\ERP\System\SyteLine\PhysicalTag\CycleCountSheet.aspx.cs:31 System_SyteLine_PhysicalTag_CycleCountSheet.Page_Load(Object sender, EventArgs e) in d:\IntranetSites\ERP\System\SyteLine\PhysicalTag\CycleCountSheet.aspx.cs:23 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 System.Web.UI.Control.OnLoad(EventArgs e) +91 System.Web.UI.Control.LoadRecursive() +74 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207 |
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
软件在开发端没有问题，发布到服务端没有问题，但交给客户有问题，出现如上错误。最终检查得出结果，开发与测试时都是使用管理员的权限去做测试，当然通过一切障碍。
可以看到下面这个存储过程，当用管理员去run时，它只跑IF节，从没有机会跑过ELSE部分的代码，现交给到客户了，用户使用其他权限去跑，问题出来了：
动态变量@Author无法被组合成的sql所识别。Insus.NET把它修改一下：
EXECUTE(@sql + ' WHERE [Author] = ' + @Author +' ORDER BY [CreateDate] DESC')
得出结论，软件开发，是用户使用之后，才会发现问题。
点击查看更多内容
为 TA 点赞
评论
共同学习，写下你的评论
评论加载中...
作者其他优质文章
正在加载中
相关文章推荐
感谢您的支持，我会继续努力的～
扫码打赏，你说多少就多少
赞赏金额会直接到老师账户
支付方式
打开微信扫一扫，即可进行扫码打赏哦