<--우선 에러메시지는 다음과 같습니다-->
=======================================================
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")
<--이부분은 스토어프로시저 부분입니다 물론 테이블은 만들어 놨구여
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