% Dim rs, connStr, Count, strSql Set rs = Server.CreateObject("ADODB.Recordset") connStr = Session("DSN") strSql = "select * from tblDogs" rs.open strSql,connStr,1,1 with rs .movefirst .movelast Count = .recordcount .close end with set rs=nothing %>
16 January, 2004