ASP Procedure Code Example

<!--METADATA TYPE="typelib" FILE="c:\program files\common files\system\ado\msado15.dll"-->

<%

set rs1 = Server.CreateObject("ADODB.COMMAND")

with rs1

 .Activeconnection = ObjConn

 .CommandText = "ProcedureName"

 .CommandType = adCmdStoredProc

 .parameters.append .Createparameter ("@task", adChar, adParamInput, 2, "00")

 .parameters.append .Createparameter ("@id", adVarChar, adParamInput, 8, id)

 .parameters.append .Createparameter ("@title", adVarChar, adParamInput, 250, "")

 .parameters.append .Createparameter ("@nick", adVarChar, adParamInput, 20, "")

 .parameters.append .Createparameter ("@duedate", adVarChar, adParamInput, 50, "")

 .parameters.append .Createparameter ("@pass", adVarChar, adParamInput, 20, "")

 Set rs = .execute

End with

If rs.eof And rs.bof Then

 'response.write "값이 없습니다."

Else

 nick = rs("nick")

 name = rs("name")

 myemail = rs("email")

End If

rs.close

Set rs = nothing

%>