(ADO)--执行存储过程的错误

2002-07-23 01:50:09 117 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

机器学习ROC曲线中的阈值thresholds 在ROC曲线上的不同点对应于不同的阈值。根据任务的具体要求，可以选择合适的阈值，以达到平衡召回率和误报率，或者根据具体应用场景调整模型的工作点。，表示样本属于正例的概率。这个概率值可以被截断为二元分类的决策，通过选择一个阈值来决定样本是被分类为正例还是负例。通过改变阈值，可以得到不同的真正例率（TPR）和假正例率（FPR），从而绘制出ROC曲线。总体来说，ROC曲线提供了模型在不同阈值下的性能综合情况，帮助分析模型的分类能力。通常来说，随着阈值的增加，TPR会减小，而FPR会增加。ROC曲线的绘制涉及。阅读详情

后台是SQL Server数据库，存储过程为GetMainTable
在执行存储过程时出现错误，
存储过程的参数和数据库中的顺序等完全一致，他去提示没提供参数。
代码如下：
<%
dim AssociatorID
dim RegionCode
dim TradeSortCode
dim HQCode
dim AssociatorLocalNO
dim EnterpriseCode
dim AssociatorName
dim Principal
dim Address
dim Postalcode
dim Telphone
dim NetworkSortCode
dim ApplyTime
dim ServiceSortCode
dim ServiceCharacterCode
dim CertifierCode
dim ret
AssociatorID=request.cookies("AssociatorID")
set cmdGetMain=server.createobject("ADODB.Command")
cmdGetMain.activeconnection=strconn
cmdGetMain.commandtype=adcmdstoredproc
cmdGetmain.commandtext="dbo.GetMainTable"
with cmdGetMains
.parameters.append .createparameter("RETURN_VALUE",adinteger,adparamreturnvalue)
if err then
response.write "error here"
else
response.write "i am right"
end if
.parameters.append .createparameter("@AssociatorID",adinteger,adparaminput,5,AssociatorID)
.parameters.append .createparameter("@RegionCode",adtinyint,adparamoutput)
.parameters.append .createparameter("@TradeSortCode",adtinyint,adparamoutput)
.parameters.append .createparameter("@HQCode",adsmallint,adparamoutput)
.parameters.append .createparameter("@AssociatorLocalNO",adsmallint,adparamoutput)
.parameters.append .createparameter("@EnterpriseCode",adchar,adparamoutput)
.parameters.append .createparameter("@AssociatorName",adchar,adparamoutput)
.parameters.append .createparameter("@Principal",adchar,adparamoutput)
.parameters.append .createparameter("@Address",adchar,adparamoutput)
.parameters.append .createparameter("@Postalcode",adchar,adparamoutput)
.parameters.append .createparameter("@Telphone",adchar,adparamoutput)
.parameters.append .createparameter("@NetworkSortCode",adtinyint,adparamoutput)
.parameters.append .createparameter("@ApplyTime",adTimeStamp,adparamoutput)
.parameters.append .createparameter("@ServiceSortCode",adtinyint,adparamoutput)
.parameters.append .createparameter("@ServiceCharacterCode",adtinyint,adparamoutput)
.parameters.append .createparameter("@CertifierCode",adtinyint,adparamoutput)

.execute ,,adExectueNoRecodes
'在这里出错，
'---------------------------------------------------*/
'Warning The Following Error Has Occurred:
'过程 'GetMainTable' 需要参数 '@Postalcode'，但未提供该参数。
'-2147217904
'Microsoft OLE DB Provider for SQL Server
'---------------------------------------------------*/
ret= .parameters("RETURN_VALUE")

if ret=1 then
RegionCode=.parameters("@RegionCode")
TradeSortCode=.parameters("@TradeSortCode")
HQCode=.parameters("@HQCode")
AssociatorLocalNO=.parameters("@AssociatorLocalNO")
EnterpriseCode=.parameters("@EnterpriseCode")
AssociatorName=.parameters("@AssociatorName")
Principal=.parameters("@Principal")
Address=.parameters("@Address")
Postalcode=.parameters("@Postalcode")
Telphone=.parameters("@Telphone")
NetworkSortCode=.parameters("@NetworkSortCode")
ApplyTime=.parameters("@ApplyTime")
ServiceSortCode=.parameters("@ServiceSortCode")
ServiceCharacterCode=.parameters("@ServiceCharacterCode")
CertifierCode=.parameters("@CertifierCode")
response.write telphone
--------------------------------------------------------------------------
创建存储过程的SQL代码如下

CREATE PROCEDURE dbo.GetMainTable
@AssociatorID int,
@RegionCode tinyint output ,
@TradeSortCode tinyint output,
@HQCode smallint output,
@AssociatorLocalNO smallint output ,
@EnterpriseCode char (10) output ,
@AssociatorName char (40) output ,
@Principal char (12) output ,
@Address char (50) output ,
@Postalcode char (6) output ,
@Telphone char (40) output ,
@NetworkSortCode tinyint output ,
@ApplyTime datetime output ,
@ServiceSortCode tinyint output ,
@ServiceCharacterCode tinyint output ,
@CertifierCode tinyint output

AS
declare @ret int;
exec @ret=VerifyPopedom @AssociatorID;//这里参数正确
if @ret=0 return 0;
select
@RegionCode=RegionCode ,
@TradeSortCode =TradeSortCode,
@HQCode =HQCode,
@AssociatorLocalNO=AssociatorLocalNO,
@EnterpriseCode=EnterpriseCode,
@AssociatorName= AssociatorName,
@Principal=Principal,
@Address=Address,
@Postalcode=Postalcode,
@Telphone =Telphone,
@NetworkSortCode =NetworkSortCode,
@ApplyTime =ApplyTime,
@ServiceSortCode =ServiceSortCode,
@ServiceCharacterCode =ServiceCharacterCode,
@CertifierCode =CertifierCode
from MainInformation
where AssociatorID=@AssociatorID;
return 1;
GO

...全文