작성일 : 12-10-12 14:20
|
[ASP] dbhelper 없이 SP 를 통해 ROW (RS 호출) [여러개의 SELECT 호출 가능]
|
 |
|
글쓴이 :
조형래
 조회 : 4,751
|
DBTarget = "spicus"
sSql = "dbo.ssp_manager_business_info_01_2_T"
Set Cmd = CmdExec(DBTarget, sSql, 4)
With Cmd
.Parameters("@MBDATE") = DATE
.Parameters("@MANAGER_ID") = EncodeA
.Parameters("@MANAGER_GU") = "M"
.Parameters("@SDATE") = SDATE
.Parameters("@EDATE") = DATEADD("d", 1, EDATE)
Set rs = .Execute()
End With
Set Cmd = Nothing
If NOT RS.EOF Then
raLevelTest = RS.GetRows()
Set rs = rs.NextRecordSet
If NOT rs.EOF Then raHayppCall = RS.GetRows()
Set rs = rs.NextRecordSet
If NOT rs.EOF Then raSchedule = RS.GetRows()
Set rs = rs.NextRecordSet
If NOT rs.EOF Then raAttList = RS.GetRows()
Set rs = rs.NextRecordSet
If NOT rs.EOF Then raLrnapp = RS.GetRows()
Set rs = rs.NextRecordSet
If NOT rs.EOF Then raCourseList = RS.GetRows()
End If
CloseRS(RS)
CloseDBCon()
|
|
1759
