Table: Anclass
NclassID NCLASS CLASSID3 Scripts Application 34 SQL Common Query 36 Essence Post 37 JSP Primary Guide 48 SQL Basics 59 Database Management 5 ------------------------------------------------------------------------------------------------ --------- Table: ACLASS
ClassID Class3 ASP Zone 4 JSP Zone 5 Database Zone ---------------------------------------- --- Code: <% DIM RSDIM SQLDIM CountSet RS = Server.createObject ("AdoDb.Recordset") SQL = "Select * from anclass order by nclassid ASC" RS.Open SQL, CONN, 1, 1%>