传统的ASP存储过程的参数 [英] classic asp stored procedures parameters

问题描述

我一直在四处寻找如何从传统的ASP调用存储过程和参数传递到它下面是我的存储过程中的正常工作

  CREATE PROCEDURE Paging_Movies
@alphaChar CHAR（1）
如
如果@alphaChar ='＃'
从电影中选择*，其中像电影'[^ A-Z]％'
其他
选择电影*，其中像电影@alphaChar +'％'
 

和我的VBScript code迄今为止 -

 设置objCon =的CreateObject（ADODB.Connection）
设置objRS =的CreateObject（ADODB.Recordset）
设置objComm =的CreateObject（ADODB.Command）objCon.Open供应商= SQLOLEDB.1;密码= XXXX;坚持安全信息= TRUE;用户ID = XXXX;初始目录=电影;数据源= XXXX-PCobjComm.ActiveConnection = objCon
objComm.CommandType = 4
objComm.CommandText =Paging_MoviesobjRS.open objComm.CommandText，objCon
 

解决方案

您正在寻找的参数属性。

  objComm.Parameters.Append objComm.CreateParameter（alphaChar，adChar，adParamInput）
objComm.Parameters（alphaChar）=一个
objComm.Execute
 

呵呵Lawdy我又写的VBScript。

I've been looking around how to call a stored procedure from classic asp and pass a parameter into it below is my stored procedure which works fine

CREATE PROCEDURE Paging_Movies
@alphaChar char(1)
AS
if @alphaChar = '#'
select * from Movies where movies like '[^a-z]%'
else
select * from Movies where movies like @alphaChar + '%'

and my vbscript code so far -

Set objCon = CreateObject("ADODB.Connection")
Set objRS = CreateObject("ADODB.Recordset")
set objComm = CreateObject("ADODB.Command")

objCon.Open "Provider=SQLOLEDB.1;Password=xxxx;Persist Security Info=True;User ID=xxxx;Initial Catalog=Movies;Data Source=xxxx-PC"

objComm.ActiveConnection = objCon
objComm.CommandType = 4
objComm.CommandText = "Paging_Movies"

objRS.open objComm.CommandText, objCon

解决方案

You're looking for the Parameters property.

objComm.Parameters.Append objComm.CreateParameter("alphaChar", adChar, adParamInput)
objComm.Parameters("alphaChar") = "a"
objComm.Execute

Oh Lawdy I'm writing VBScript again.

这篇关于传统的ASP存储过程的参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！