? 질문 @intidx매개변수가 제공되지 않았다고 하는데...

[미루]

<--우선 에러메시지는 다음과 같습니다-->
=======================================================
Server]'sp_address_read' 프로시저에 필요한 '@intidx' 매개 변수가 제공되지 않았습니다.
/hung/address_list.asp, line 38
=======================================================
<--이부분은 asp코딩부분이고...-->
dim objconn
dim strconnection
set objconn = server.createobject("adodb.connection")
strconnection = "dsn=dblogin;uid=APTMENT;pwd=;"
objconn.open strconnection
dim intidx
dim strname
dim strtel
dim stremail
dim strregid
dim intsex
dim intprevidx
dim intnextidx
dim strprevname
dim strnextname

intidx = request.querystring("idx")
dim objcmd
set objcmd = server.createobject("adodb.command")

with objcmd
.activeconnection = objconn
.commandtext = "sp_address_read"
.commandtype = adcmdstoredproc
.parameters.append .createparameter("@intidx", adinteger, adparaminput, 0)
.parameters.append .createparameter("@strname", advarwchar, adparamoutput, 20)
.parameters.append .createparameter("@strtel", advarwchar, adparamoutput, 15)
.parameters.append .createparameter("@stremail", advarwchar, adparamoutput, 50)
.parameters.append .createparameter("@strregid", advarwchar, adparamoutput, 15)
.parameters.append .createparameter("@intsex", adinteger, adparamoutput, 0)
.parameters.append .createparameter("@intprevidx", adinteger, adparamoutput, 0)
.parameters.append .createparameter("@intnextidx", adinteger, adparamoutput, 0)
.parameters.append .createparameter("@strprevname", advarchar, adparamoutput, 20)
.parameters.append .createparameter("@strnextname", advarchar, adparamoutput, 20)
.parameters("@intidx") = intidx
.execute , , adexecutenorecords <--이부분이 에러라는데...
strname = .parameters("@strname")
strtel = .parameters("@strtel")
stremail = .parameters("@stremail")
strregid = .parameters("@strregid")
intsex = .parameters("@intsex")
intprevidx = .parameters("@intprevidx")
intnextidx = .parameters("@intnextidx")
strprevname = .parameters("@strprevname")
strnextname = .parameters("@strnextname")
end with

objconn.close
set objcmd = nothing
set objconn = nothing

=========================================================

<--이부분은 스토어프로시저 부분입니다 물론 테이블은 만들어 놨구여
CREATE proc sp_address_read
@intidx int,
@strname varchar(20) output,
@strtel varchar(15) output,
@stremail varchar(50) output,
@strregid varchar(15) output,
@intsex int output,
@intprevidx int output,
@intnextidx int output,
@strprevname varchar(20) output,
@strnextname varchar(20) output
as
begin
select @strname = name, @strtel = tel, @stremail = email, @strregid = regid, @intsex = sex
from address
where idx = @intidx
if exists ( select * from address where idx < @intidx )
begin
select @intprevidx = max(idx) from address where idx < @intidx
select @strprevname = name from address where idx = @intprevidx
end
if exists ( select * from address where idx > @intidx)
begin
select @intnextidx = min(idx) from address where idx > @intidx
select @strnextname = name from address where idx = @intnextidx
end
end
GO