我的也是出现这个问题,我上传图片后,点确定出现这种情况,谢谢回复
错误类型:
Microsoft JET Database Engine (0x80040E21)
字段太小而不能接受所要添加的数据的数量。试着插入或粘贴较少的数据。
/Admin/info/saveedit.asp, 第 73 行
<%@ codepage ="936" %>
<%
ds="../../"
%>
<%
if request.form("newsid")="" then
Response.Redirect ("../admin/admin_login.asp")
end if
if Chkrequest(request.form("newsid")) then
newsid=request.form("newsid")
else
Response.Redirect ("../admin/admin_login.asp")
end if
%>
<!--#include file="../../conn/adminconn.asp"-->
<!--#include file="../../inc/safe.asp"-->
<link rel="stylesheet" type="text/css" href="../css/style.css">
<%
if Not ChkPost then
response.redirect ("../admin/admin_login.asp")
response.end
end if
IncludePic=Replace_Text(request.form("IncludePic"))
title=Replace_Text(request.form("title"))
TitleFontColor=request.form("TitleFontColor")
if IncludePic>"" then
title=IncludePic&title
end if
if TitleFontColor>"" then
title="<font color="&TitleFontColor&">"&title&"</font>"
end if
typeid=Replace_Text(request.form("typeid"))
tjnews=Replace_Text(request.form("tjnews"))
if tjnews="" then
tjnews=0
else
tjnews=1
end if
tjhome=Replace_Text(request.form("tjhome"))
if tjhome="" then
tjhome=0
else
tjhome=1
end if
homepic=Replace_Text(request.form("homepic"))
if homepic="" then
homepic=0
else
homepic=1
end if
homehot=Replace_Text(request.form("homehot"))
if homehot="" then
homehot=0
else
homehot=1
end if
nfrom=Replace_Text(request.form("nfrom"))
author=Replace_Text(request.form("author"))
editor=Replace_Text(request.form("editor"))
picture=Replace_Text(request.form("picture"))
content=request.form("content")
if content="" then
response.write"<SCRIPT language=JavaScript>alert('您没有填写详细内容,请返回重新填写!');"
response.write"javascript:history.go(-1)</SCRIPT>"
response.end
end if
set rs=server.CreateObject ("adodb.recordset")
sql="select * from job_hrnews where newsid="&newsid&""
rs.open sql,conn,1,3
rs("title")=title
rs("typeid")=typeid
rs("tjnews")=tjnews
rs("tjhome")=tjhome
rs("homepic")=homepic
rs("homehot")=homehot
rs("author")=author
rs("nfrom")=nfrom
if picture="" then picture="nopicture.gif"
rs("picture")=picture
rs("content")=content
rs("editor")=editor
rs("dateandtime")=now()
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>操作成功</title>
</head>
<table cellpadding=2 cellspacing=1 border=0 width=400 class=tableBorder align=center><TR>
<TH class=tableHeaderText colSpan=2 height=25>修改咨讯信息</TH>
<TR><tr><td height=85 valign=top class=forumRow><div align=center><br><br>
修改咨讯信息成功!</div></td></tr><tr align=center><td height=30 class=forumRowHighlight><a href='index.asp'><< 返回上一页</a></td></tr></table>
</body>
</html>
<br>
<!--#include file="../inc/copy.asp" -->
參考答案:把出错那行那个数据库的字段大小改大一点。
你上面写的是73行,那对应的是title字段,一般access的文本字段默认是50,你可以改成最大的255,或把类型改成备注型就可以了。
或者你也可以只保存前50个字符,这样写就行了:rs("title")=left(title,50)