Hi, Let me first say I am a novice with ASP.
on this page: http://aasg.brinkster.net/admin/user_admin.asp
, I am trying to show users in database based on the access level. I got dreamweaver to write the code below for me. However, it is not working for ALL USERS. The way the code is right now, when there is no URL parameter, the accesslevel is set to 1, so instead of all users, users with accesslevel 1 (called "subscribe") are shown. How do I get it to show ALL users, regardless of their accesslevel? I think I need to write a separate if/then statement saying if there is no accesslevel URL parameter, then use this other recordset. But I am not sure how I would do that.
Here's the dreamweaver code as it is right now:
rsUsers__MMColParam = "1"
sslevel") <> "") Then
rsUsers__MMColParam = Request.QueryString("acces
Set rsUsers = Server.CreateObject("ADODB
rsUsers.ActiveConnection = MM_connSane1_STRING
rsUsers.Source = "SELECT * FROM qryUser_Admin WHERE userLevelID = " + Replace(rsUsers__MMColPara
m, "'", "''") + " ORDER BY lname ASC"
rsUsers.CursorType = 0
rsUsers.CursorLocation = 2
rsUsers.LockType = 1
rsUsers_numRows = 0