<./>.dev./hood

<script language="javascript" runat="server" src="json2.js"></script>
<%
   Response.AddHeader "Content-Type", "application/json"
 
    'DB 연결
    SbDBConn objConn
 
   sData = "{""date"":[""2015-02-26""], ""data"":["_
            & "{""ID"":""test01"",""NAME"":""홍길동""},{""ID"":""test02"",""NAME"":""보리""}]}"
    'request.form("DATA")
   
   Set sData = JSON.parse(sData)
 
   nCnt = 0
   itemCnt = sData.data.length
   sSalesDay = sData.date
 
   For Each o In sData.data
      Set objCmd = Server.CreateObject("ADODB.Command")
      With objCmd
         .ActiveConnection = objConn
         .CommandType = adCmdStoredProc
         .CommandText = "USP_TEST"
         .Parameters.Append .CreateParameter("RETURN_VALUE", adInteger, adParamReturnValue)
         .Parameters.Append .CreateParameter("@sId", adVarchar, adParamInput, 12, o.ID)
         .Parameters.Append .CreateParameter("@sName", adVarchar, adParamInput, 100, o.NAME)
         .Execute , , adExecuteNoRecords
         nRetValue  = .Parameters("RETURN_VALUE")
      End With
      Set objCmd = Nothing
 
      If nRetValue = "1" Then
         nCnt = nCnt + 1
         IF nCnt = itemCnt THEN
            sJsonText = "{'RESULT':'Y'}"
         ELSE
            sJsonText = "{'RESULT':'T'}"
         END IF
      Else
         sJsonText = "{'RESULT':'E'}"
      End If
 
   Next
 
   'sJsonText = "{'data':'"& sData.data.length &"'}"
    sJsonText = Replace(sJsonText,"'",Chr(34))
    Response.write sJsonText
   
   SbDbClose objConn
%>


그냥 참고용...

어느 분께서 만드셨는데 URL 을 잊어버림 죄송...