Line 366: <%
Line 367: System.Data.SqlClient.SqlDataReader sdr = Connection.GetTable("*,(SELECT COUNT(*) FROM products WITH(NOLOCK) WHERE pcid = pc.pcid AND sid = 2) AS total", "productcategories pc WITH(NOLOCK)", "pc.sid = 2 AND pc.pcid NOT IN (5,15)", "pc.ordercol ASC");
Line 368: while (sdr.Read())
Line 369: {
Line 370: Response.Write("<li>");
|