asp+access数据编辑后不能修改
各位帮忙看一下asp+access做的网站 数据编辑点击修改提示修改成功,但是并没有修改代码如下:changewebconfig.asp:
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!--#include file="error.ini"-->
<!--#include file="../MD5/md5.asp" -->
<!--#include file="conn.asp"-->
<%if session("flag")>1 then
response.write "<script>alert('您的操作权限不够!');history.back();</script>"
response.end
end if
%>
<% function HTMLEncode1(fString)
fString = Replace(fString, "http://", "")
HTMLEncode1 = fString
end function
%>
<%
set rs=server.createobject("adodb.recordset")
rs.open "select * from home",conn,1,3
rs("homes")=trim(request("homes"))
rs("en_name")=trim(request("en_name"))
url=HTMLEncode1(request("url"))
rs("weburl")=url
rs("urls")=request("urls")
rs("fuwu")=request("fuwu")
rs("nj_tel")=request("nj_tel")
rs("hz_tel")=request("hz_tel")
rs("fz_tel")=request("fz_tel")
rs("cs_tel")=request("cs_tel")
rs("nc_tel")=request("nc_tel")
rs("gonggao")=request("gonggao")
rs("wh_tel")=request("wh_tel")
rs("webmail")=request("webmail")
rs("sd_tel")=request("sd_tel")
rs("sitephone")=request("phone")
rs("Mob_phone")=request("Mob_phone")
rs("qqone")=request("qqone")
rs("Mob_phone")=trim(request("Mob_phone"))
rs("fax")=request("fax")
rs("mail")=request("mail")
rs("address")=request("address")
rs("en_address")=request("en_address")
rs("webtitle")=request("webtitle")
rs("gd_mob")=request("gd_mob")
rs("en_webtitle")=request("en_webtitle")
rs("beian")=request("beian")
rs("lxr")=request("lxr")
rs("en_lxr")=request("en_lxr")
rs("zip")=request("zip")
rs("keywords")=request("keywords")
rs("en_keywords")=request("en_keywords")
' rs("banquan")=request("banquan")
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
'response.redirect "main.asp"
response.write "<script>alert('修改成功!');window.location.href='"&Request.ServerVariables("HTTP_REFERER")&"';</script>"
'response.redirect Request.ServerVariables("HTTP_REFERER")
%> --------------------编程问答-------------------- 这是第一页
<script Language="JavaScript" Type="text/javascript">
<!--
function IsDigit()
{ return ((event.keyCode >= 48) && (event.keyCode <= 57));
}
function checkdata()
{
if(document.form1.homes.value=="")
{ alert("请添上站点名称");
form1.homes.focus();
return false;
}
if(document.form1.url.value=="")
{alert("请添上国际域名");
form1.url.focus();
return false;
}
if(document.form1.beian.value=="")
{alert("请添上备案信息");
form1.beian.focus();
return false;
}
if(document.form1.phone.value=="")
{ alert("请添上联系电话");
form1.phone.focus();
return false;
}
if(document.form1.mail.value=="")
{ alert("请添上邮箱地址");
form1.mail.focus();
return false;
}
if(document.form1.mail.value.length!=0)
if (document.form1.mail.value.charAt(0)=="." ||
document.form1.mail.value.charAt(0)=="@"||
document.form1.mail.value.indexOf('@', 0) == -1 ||
document.form1.mail.value.indexOf('.', 0) == -1 ||
document.form1.mail.value.lastIndexOf("@")==document.form1.mail.value.length-1 ||
document.form1.mail.value.lastIndexOf(".")==document.form1.mail.value.length-1)
{alert("Email地址格式不正确!");
document.form1.mail.focus();
return false;
}
if(document.form1.address.value=="")
{ alert("请添上联系地址");
form1.address.focus();
return false;
}
}
//-->
</script>
<table border="0" width="100%" cellpadding="2" cellspacing="1" height="474" class="border">
<tr bgcolor="#009ACE">
<td height="25" colspan="2" nowrap class="font_9_1"><div align="center"><font color="#FFFFFF"><b>网站信息</b></font></div></td>
</tr>
<%set rs=server.createobject("adodb.recordset")
rs.open "select * from home",conn,1,3
%>
<form method="post" name="form1" onSubmit="return checkdata();" action="changewebconfig.asp">
<tr>
<td align="right" height="25" valign="middle" class="tdbg" bgcolor="#F3F5F5"><div align="center"><span class="font_9">公司中文名称:</span></div></td>
<td height="25" class="tdbg" bgcolor="#F3F5F5"><input class="smallInput" name="homes" size="50" maxlength="255" value="<%=rs("homes")%>" style="background-color:#CCFFCC;color:#FF0000"> </td>
</tr>
<tr>
<td align="right" height="25" valign="middle" class="tdbg" bgcolor="#F3F5F5"><div align="center"><span class="font_9">公司英文名称:</span></div></td>
<td height="25" class="tdbg" bgcolor="#F3F5F5"><input class="smallInput" name="en_name" size="50" maxlength="255" value="<%=rs("en_name")%>" style="background-color:#CCFFCC;color:#FF0000"> </td>
</tr>
<tr>
<td align="right" height="25" valign="middle" class="tdbg" bgcolor="#F3F5F5"><div align="center"><span class="font_9">国际域名:</span></div></td>
<td height="25" class="tdbg" bgcolor="#F3F5F5"><input class="smallInput" name="url" size="30" maxlength="255" value="<%=rs("weburl")%>"> </td>
</tr>
<!--
<tr>
<td width="24%" align="right" height="25" valign="middle" class="tdbg" bgcolor="#F3F5F5">
<p align="center"><span class="font_9">备案信息:</span></td>
<td width="76%" height="25" class="tdbg" bgcolor="#F3F5F5"><input class="smallInput" name="urls" size="30" maxlength="255" value="<%=rs("urls")%>">
</td>
</tr>
-->
<tr>
<td height="25" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">联系方式:</div></td>
<td align="right" height="9" valign="middle" class="tdbg"><div align="left">电话:
<input name="phone" type="text" value="<%=rs("sitephone")%>" size="30" maxlength="50">
手机:
<input name="Mob_phone" type="text" value="<%=rs("Mob_phone")%>" size="26" maxlength="50">
<span class="STYLE1">*</span> 多个号码请用<br>隔开!<br>
传真:
<input name="fax" type="text" value="<%=rs("fax")%>" size="23" maxlength="20">
</div></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">联系QQ:</div></td>
<td align="right" height="9" valign="middle" class="tdbg"><div align="left">Q Q:
<input type="text" name="qqone" size="23" value="<%=rs("qqone")%>">
</div></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">邮箱地址:</div></td>
<td align="right" height="9" valign="middle" class="tdbg"><div align="left">邮箱:
<input type="text" name="mail" size="23" value="<%=rs("mail")%>">
</div></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">公司中文地址:</div></td>
<td align="right" height="9" valign="middle" class="tdbg"><div align="left">
<input name="address" type="text" value="<%=rs("address")%>" size="50" maxlength="50">
</div></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">公司英文地址:</div></td>
<td align="right" height="9" valign="middle" class="tdbg"><div align="left">
<input name="en_address" type="text" value="<%=rs("en_address")%>" size="50" maxlength="50">
</div></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">联 系 人:</div></td>
<td align="right" height="9" valign="middle" class="tdbg"><div align="left">
<input name="lxr" type="text" value="<%=rs("lxr")%>" size="20" maxlength="10">
</div></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">联 系 人(英文):</div></td>
<td align="right" height="9" valign="middle" class="tdbg"><div align="left">
<input name="en_lxr" type="text" id="en_lxr" value="<%=rs("en_lxr")%>" size="20" maxlength="10">
</div></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">邮 编:</div></td>
<td align="right" height="9" valign="middle" class="tdbg"><div align="left">
<input name="zip" type="text" value="<%=rs("zip")%>" size="20" maxlength="6" title="只能是数字" onKeyUp="if(isNaN(value))execCommand('undo')">
</div></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">网站中文标题:</div></td>
<td align="right" height="9" valign="middle" class="tdbg"><div align="left">
<input name="webtitle" type="text" value="<%=rs("webtitle")%>" size="50" maxlength="50">
</div></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">网站英文标题:</div></td>
<td align="right" height="9" valign="middle" class="tdbg"><div align="left">
<input name="en_webtitle" type="text" value="<%=rs("en_webtitle")%>" size="50" maxlength="250">
</div></td>
</tr>
<tr>
<td height="20" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">本网站备案号:</div></td>
<td align="right" height="4" valign="middle" class="tdbg"><div align="left">
<input name="beian" type="text" value="<%=rs("beian")%>" size="50" maxlength="50">
</div></td>
</tr>
<tr>
<td height="4" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">企业邮箱地址:</div></td>
<td align="right" height="4" valign="middle" class="tdbg"><div align="left">
<input name="webmail" type="text" value="<%=rs("webmail")%>" size="50">
(请不要输入http://)</div></td>
</tr>
<tr>
<td height="12" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">网站关键字(中):</div></td>
<td height="4" align="right" valign="middle" class="tdbg"><div align="left">
<textarea rows="4" name="keywords" cols="53"><%=rs("keywords")%></textarea>
</div></td>
</tr>
<tr>
<td height="12" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">网站公告管理:</div></td>
<td height="4" align="right" valign="middle" class="tdbg">
<div align="left">
<textarea rows="4" name="gonggao" cols="53"><%=rs("gonggao")%></textarea>
支持html代码 </div></td>
</tr>
<tr>
<td height="12" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">网站关键字(英):</div></td>
<td height="4" align="right" valign="middle" class="tdbg"><div align="left">
<textarea rows="4" name="en_keywords" cols="53"><%=rs("en_keywords")%></textarea>
</div></td>
</tr>
<tr>
<td height="12" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">服务宗旨:</div></td>
<td height="4" align="right" valign="middle" class="tdbg"><div align="left">
<textarea rows="14" name="fuwu" cols="53"><%=rs("fuwu")%></textarea>
</div></td>
</tr>
<!--
<tr>
<td height="9" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg" ><div align="center">版权信息:</div></td>
<td align="right" height="9" valign="middle" class="tdbg"><div align="left">
<textarea rows="4" name="banquan" cols="53"><%=rs("banquan")%></textarea>
</div></td>
</tr>
-->
<tr bgcolor="#E1F4EE">
<td width="24%" height="4" align="right" valign="middle" bgcolor="#DEF0FA" class="tdbg"> </td>
<td width="76%" height="4" bgcolor="#DEF0FA" class="tdbg"><font size="2">
<input type="submit" value=" 修 改 " name="cmdok" >
<input type="reset" value=" 重 写 " name="cmdcancel">
</font></td>
</tr>
</form>
</table>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
--------------------编程问答-------------------- 你应该去ASP问问。
补充:.NET技术 , ASP.NET