Nesting the loop, Important thing to note make sure that you use recordset<\/p>\n
\u00a0<\/p>\n
<%@ LANGUAGE=”VBSCRIPT” %>
\n<% response.cachecontrol = “Public” %>
\n<%Response.Buffer = False%><\/p>\n
<HTML>
\n<HEAD>
\n<TITLE>Title<\/TITLE>
\n<\/HEAD><\/p>\n
<%
\nSet conn= Server.CreateObject(“ADODB.Connection”)
\nconn.ConnectionTimeout = Session(“Support_ConnectionTimeout”)
\nconn.CommandTimeout = Session(“Support_CommandTimeout”)
\nconn.Open Session(“Support_ConnectionString”), Session(“Support_RuntimeUserName”), Session(“Support_RuntimePassword”)
\nSet cmdTemp = Server.CreateObject(“ADODB.Command”)
\nSet rs1 = Server.CreateObject(“ADODB.Recordset”)
\ncmdTemp.CommandText = “exec sp”
\ncmdTemp.CommandType = 1
\nSet cmdTemp.ActiveConnection = conn
\nrs1.Open cmdTemp, , 0, 1
\n%><\/p>\n
\u00a0<\/p>\n
<% If Not rs1.EOF Or Not rs2.BOF Then %><\/p>\n
<body><\/p>\n
………..First Stuff……………<\/p>\n
<%dim CurrentContract%>
\n<%CurrentContract = 0%><\/p>\n
\u00a0<% do While NOT adoOpenCalls.EOF %>
\n\ufffd
\n\u00a0\u00a0<%CurrentContract = adoOpenCalls(“con_id”).value%><\/p>\n
\u00a0\u00a0…………1st Loop STUFF………
\n\u00a0\ufffd
\n\u00a0\u00a0\u00a0\u00a0<%count = 0%>
\n\u00a0\u00a0\u00a0\u00a0<%
\n\u00a0\u00a0\u00a0\u00a0Set rs1= Server.CreateObject(“ADODB.Recordset”)
\n\u00a0\u00a0\u00a0\u00a0cmdTemp.CommandText = “exec sp” & CurrentContract\ufffd
\n\u00a0\u00a0\u00a0\u00a0cmdTemp.CommandType = 1
\n\u00a0\u00a0\u00a0\u00a0Set cmdTemp.ActiveConnection = conn
\n\u00a0\u00a0\u00a0\u00a0adoLoopIncidents.Open cmdTemp, , 0, 1\u00a0\u00a0\ufffd
\n\u00a0\u00a0\u00a0\u00a0%><\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\ufffd
\n\u00a0\u00a0\u00a0\u00a0\ufffd
\n\u00a0\u00a0\u00a0\u00a0\u00a0<%
\n\u00a0\u00a0\u00a0\u00a0\u00a0Do while not adoLoopIncidents.eof
\n\u00a0\u00a0\u00a0\u00a0\u00a0count = count + 1
\n\u00a0\u00a0\u00a0\u00a0\u00a0%>
\n\u00a0\u00a0\u00a0\ufffd
\n\u00a0\u00a0\u00a0\u00a0\u00a0…………2nd Loop STUFF………
\n\u00a0\u00a0\u00a0\u00a0\ufffd
\n\u00a0\u00a0\u00a0\u00a0\u00a0<%adoLoopIncidents.movenext%>
\n\u00a0\u00a0\u00a0\u00a0\u00a0<%loop%><\/p>\n
\u00a0\u00a0………….Stuff at end of loop………..<\/p>\n
\u00a0\u00a0<% adoOpenCalls.movenext %>
\n\u00a0\u00a0<%loop%>
\n<%else%>
\n……..else stuff………
\n<%end if%><\/p>\n
……..Last Stuff………<\/p>\n
<%
\nadoOpenCalls.Close
\nSet adoOpenCalls = Nothing
\n%><\/p>\n
<\/BODY>
\n<\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"
Nesting the loop, Important thing to note make sure that you use recordset \u00a0 <%@ LANGUAGE=”VBSCRIPT” %> <% response.cachecontrol = “Public” %> <%Response.Buffer = False%> <HTML> <HEAD> <TITLE>Title<\/TITLE> <\/HEAD> <% Set conn= Server.CreateObject(“ADODB.Connection”) conn.ConnectionTimeout =<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[21],"tags":[311,651,1131,2081,2341],"class_list":["post-84","post","type-post","status-publish","format-standard","hentry","category-microsoft","tag-asp","tag-do","tag-loop","tag-sql","tag-while"],"jetpack_publicize_connections":[],"yoast_head":"\r\n