Nesting the loop, Important thing to note make sure that you use recordset <%@ LANGUAGE=”VBSCRIPT” %> <% response.cachecontrol = “Public” %> <%Response.Buffer = False%> <HTML> <HEAD> <TITLE>Title</TITLE> </HEAD> <% Set conn= Server.CreateObject(“ADODB.Connection”) conn.ConnectionTimeout = Session(“Support_ConnectionTimeout”) conn.CommandTimeout = Session(“Support_CommandTimeout”) conn.Open Session(“Support_ConnectionString”), Session(“Support_RuntimeUserName”), Session(“Support_RuntimePassword”) Set cmdTemp = Server.CreateObject(“ADODB.Command”) Set rs1 = Server.CreateObject(“ADODB.Recordset”) cmdTemp.CommandText = “exec sp” …
Tag Archive: While
Permanent link to this article: http://www.tsls.co.uk/index.php/2008/09/24/asp-nested-loop-doing-the-loop/