我在页面中定义了一个记录集member,为login表,用id过滤,在页面中插入动态显示用户名和等级字段,预览页面正常.然后我在页面中插入一个form,名为form1,接着又插入一个文本框,名为uplevel,我要用这个文本框来更新login表中的level字段.添加一个确认按钮submit.我在server behaviors中选择update record:
Connection=login
Table Record Update=login
Select Record Form=member
Unique Key Column=id 以选择Numeric
after Updating,Go To=memberuplevelok.asp
Get values From=form1
Form Elements=uplevel updates column "level"(Text)
Column=level
Sumbit As=Text
然后OK,但预览是无法正常更新记录.
提示:您要访问的页面有问题,不能被显示!
url还停留在原页面上,memberuplevel.asp?id=28
这是为什么?我在的页面有问题吗?请高手指点一二.
access数据库中login表中的level字段为文本型,最大长度20,默认值为"普通用户"(用的是英文标点)为必添字段,不允许空字符.
下面是这个页面的源文件:
<%@LANGUAGE="javascript"%>
<%
// *** Logout the current user.
MM_Logout = String(Request.ServerVariables("URL")) + "?MM_Logoutnow=1";
if (String(Request("MM_Logoutnow"))=="1") {
Session.Abandon();
var MM_logoutRedirectPage = "../index.asp";
// redirect with URL parameters (remove the "MM_Logoutnow" query param).
if (MM_logoutRedirectPage == "") MM_logoutRedirectPage = String(Request.ServerVariables("URL"));
if (String(MM_logoutRedirectPage).indexOf("?") == -1 && Request.QueryString != "") {
var MM_newQS = "?";
for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) {
if (String(items.item()) != "MM_Logoutnow") {
if (MM_newQS.length > 1) MM_newQS += "&";
MM_newQS += items.item() + "=" + Server.URLencode(Request.QueryString(items.item()));
}
}
if (MM_newQS.length > 1) MM_logoutRedirectPage += MM_newQS;
}
Response.Redirect(MM_logoutRedirectPage);
}
%>
<%
// *** Restrict Access To Page: Grant or deny access to this page
var MM_authorizedUsers="";
var MM_authFailedURL="index.asp";
var MM_grantAccess=false;
if (String(Session("MM_Username")) != "undefined") {
if (true || (String(Session("MM_UserAuthorization"))=="") || (MM_authorizedUsers.indexOf(String(Session("MM_UserAuthorization"))) >=0)) {
MM_grantAccess = true;
}
}
if (!MM_grantAccess) {
var MM_qsChar = "?";
if (MM_authFailedURL.indexOf("?") >= 0) MM_qsChar = "&";
var MM_referrer = Request.ServerVariables("URL");
if (String(Request.QueryString()).length > 0) MM_referrer = MM_referrer + "?" + String(Request.QueryString());
MM_authFailedURL = MM_authFailedURL + MM_qsChar + "accessdenied=" + Server.URLEncode(MM_referrer);
Response.Redirect(MM_authFailedURL);
}
%>
<%
// *** Edit Operations: declare variables
// set the form action variable
var MM_editAction = Request.ServerVariables("URL");
if (Request.QueryString) {
MM_editAction += "?" + Request.QueryString;
}
// boolean to abort record edit
var MM_abortEdit = false;
// query string to execute
var MM_editQuery = "";
%>
<%
// *** Update Record: set variables
if (String(Request("MM_update")) != "undefined" &&
String(Request("MM_recordId")) != "undefined") {
var MM_editConnection = MM_login_STRING;
var MM_editTable = "login";
var MM_editColumn = "id";
var MM_recordId = "" + Request.Form("MM_recordId") + "";
var MM_editRedirectUrl = "memberuplevelok.asp";
var MM_fieldsStr = "levels|value";
var MM_columnsStr = "level|',none,''";
// create the MM_fields and MM_columns arrays
var MM_fields = MM_fieldsStr.split("|");
var MM_columns = MM_columnsStr.split("|");
// set the form values
for (var i=0; i+1 < MM_fields.length; i+=2) {
MM_fields[i+1] = String(Request.Form(MM_fields[i]));
}
// append the query string to the redirect URL
if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.length > 0) {
MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + Request.QueryString;
}
}
%>
<%
// *** Update Record: construct a sql update statement and execute it
if (String(Request("MM_update")) != "undefined" &&
String(Request("MM_recordId")) != "undefined") {
// create the sql update statement
MM_editQuery = "update " + MM_editTable + " set ";
for (var i=0; i+1 < MM_fields.length; i+=2) {
var formVal = MM_fields[i+1];
var MM_typesArray = MM_columns[i+1].split(",");
var delim = (MM_typesArray[0] != "none") ? MM_typesArray[0] : "";
var altVal = (MM_typesArray[1] != "none") ? MM_typesArray[1] : "";
var emptyVal = (MM_typesArray[2] != "none") ? MM_typesArray[2] : "";
if (formVal == "" || formVal == "undefined") {
formVal = emptyVal;
} else {
if (altVal != "") {
formVal = altVal;
} else if (delim == "'") { // escape quotes
formVal = "'" + formVal.replace(/'/g,"''") + "'";
} else {
formVal = delim + formVal + delim;
}
}
MM_editQuery += ((i != 0) ? "," : "") + MM_columns[i] + " = " + formVal;
}
MM_editQuery += " where " + MM_editColumn + " = " + MM_recordId;
if (!MM_abortEdit) {
// execute the update
var MM_editCmd = Server.CreateObject('ADODB.Command');
MM_editCmd.ActiveConnection = MM_editConnection;
MM_editCmd.CommandText = MM_editQuery;
MM_editCmd.Execute();
MM_editCmd.ActiveConnection.Close();
if (MM_editRedirectUrl) {
Response.Redirect(MM_editRedirectUrl);
}
}
}
%>
<%
var member__MMColParam = "1";
if(String(Request.QueryString("id")) != "undefined") {
member__MMColParam = String(Request.QueryString("id"));
}
%>
<%
var member = Server.CreateObject("ADODB.Recordset");
member.ActiveConnection = MM_login_STRING;
member.Source = "SELECT * FROM login WHERE id = "+ member__MMColParam.replace(/'/g, "''") + "";
member.CursorType = 0;
member.CursorLocation = 2;
member.LockType = 3;
member.Open();
var member_numRows = 0;
%>
:::龙行天下主题社区:::
1.新闻管理 |
用户名:<%=(member.Fields.Item("nick").value)%>
用户当前等级:<%=(member.Fields.Item("level").value)%>
新等级:
1.普通会员
2.VIP会员
3.贵宾
4.版主
5.社区元老
6.社区创始人
7.社区管理员
|
2.论坛管理 |
3.用户管理 |
4.新闻中心管理 |
5.下载区管理 |
6.会员文章管理 |
7.商店街管理 |
8.拓展功能 |
9.拓展功能 |
|
版权所有:SYAWN 保留所有原创设计和源文件及相关原创资源
longsky.com © ALL Right Reserved
<%
member.Close();
%>