以下代码，我在提交时，没有提示出错，但是插入的select中的“resenduser”到表里，后发现是空值，大家帮帮忙！
<% if request("editsignfile")="转发" then
userid=request.form("userid")
resenduser=request.form("resenduser")
set conn=opendb("oabusy","conn","accessdsn")
set rs1=server.createobject("adodb.recordset")
sql = "update signfile set "
sql = sql & "resenduser=" & SqlStr(resenduser) & "where userid='"&userid&"'" SqlStr(resenduser) 是哪来的?还有就是where与前面没有空格
conn.Execute sql
response.write("转发成功!")
end if
%>
<form action="sendfile.asp" method="post">
<table align="center">
<tr>
<td>
<select name="resenduser">
<option selected>请选择转发人</option>
<% set conn=opendb("oabusy","conn","accessdsn")
set rsname=server.createobject("adodb.recordset")
sql="select distinct name from userinf"
rsname.open sql,conn,1,1
do while not rsname.eof and not rsname.bof %>
<option value="<%=rsname("name")%>" ><%=rsname("name")%></option>
<% rsname.movenext
loop %>
</select>
</td>
</tr>
</table>
</form>

以下代码，我在提交时，没有提示出错，但是插入的select中的“resenduser”到表里，后发现是空值，大家帮帮忙！
<% if request("editsignfile")="转发" then
userid=request.form("userid")
resenduser=request.form("resenduser")讲求的值在这！
set conn=opendb("oabusy","conn","accessdsn")
set rs1=server.createobject("adodb.recordset")
sql = "update signfile set "
sql = sql & "resenduser=" & SqlStr(resenduser) & "where userid='"&userid&"'"这个空格可能是复制时出错，在代码里是有空格的
conn.Execute sql
response.write("转发成功!")
end if
%>
<form action="sendfile.asp" method="post">
<table align="center">
<tr>
<td>
<select name="resenduser">
<option selected>请选择转发人</option>
<% set conn=opendb("oabusy","conn","accessdsn")
set rsname=server.createobject("adodb.recordset")
sql="select distinct name from userinf"
rsname.open sql,conn,1,1
do while not rsname.eof and not rsname.bof %>
<option value="<%=rsname("name")%>" ><%=rsname("name")%></option>
<% rsname.movenext
loop %>
</select>
</td>
</tr>
</table>
</form>

如果 SqlStr(resenduser) 反回的是空值的话,而在数据库里也没设此字段允许为空的话,就会发生上面的错误,你可以先判断一下它是否为空,或是在数库中设为允许为空,试试呀