急等:ASP错误

[fhxy0010]

各位请问:
Microsoft OLE DB Provider for SQL Server (0x80040E21)
多步 OLE DB 操作产生错误。如果可能，请检查每个 OLE DB 状态值。没有工作被完成。是由于什么原因,怎么解决?

[HLxiuluo]

[sum}

[chenjianyong94]

数据库没连上，要不就是连接没有及时的关闭和打开.

[hookee]

可能SQL语句有问题，数据类型不对之类的，具体要进一步检查

[fhxy0010]

代码如下:
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select Employee_Department.Department_ID,Employee_Branch.Branch_ID,Employee_Branch.Branch_Name,Employee_Department.Department_Name from Employee_Department,Employee_Branch where Employee_Department.Branch_ID=Employee_Branch.Branch_ID and Employee_Branch.Branch_ID<>5 and Employee_Branch.Branch_ID<>2 order by Employee_Branch.Branch_ID,Employee_Department.Department_ID",conn,1,1
do while not rs.eof
if len(trim(rs("Department_Name")))=0 then%><optgroup label="<%=rs("Branch_Name")%>"></optgroup><%else%>
<option value="<%=rs("Branch_Name")%>--><%=rs("Department_Name")%>"<%if rs("Department_ID")=session("department_id") then%> selected="selected"<%end if%>><%=rs("Branch_Name")%>--><%=rs("Department_Name")%></option>
temp_id=rs("branch_id")
temp1_id=rs("department_id")
<%end if
rs.movenext
loop%>
<option value="柳志祥">柳志祥</option>
<option value="夏建平">夏建平</option>

</select>
联系电话：
<input name="op_tel" type="text" id="op_tel" size="10" /></td>
</tr>
<tr>
<td>审批人：</td>
<td><select name ="op_spren" size="1">
<%
set rss=server.CreateObject("adodb.recordset")
rss.open "exec sp_department_zw temp_id,temp1_ID",conn,1,1

[qinglingjian]

select Employee_Department.Department_ID,Employee_Branch.Branch_ID,Employee_Branch.Branch_Name,Employee_Department.Department_Name from Employee_Department,Employee_Branch where Employee_Department.Branch_ID=Employee_Branch.Branch_ID and Employee_Branch.Branch_ID <>5 and Employee_Branch.Branch_ID <>2 order by Employee_Branch.Branch_ID,Employee_Department.Department_ID
这个sql语句，你在查询分析器里执行一下试试。

[toury]

用某种游标打开某个记录集后交叉使用了。比如对一张表重复用不同方法做更新操作就会引起这个错误

[fhxy0010]

这个SQL语句在查询分析器里有结果,没有错误!

[hookee]

参数是数字的话:
rss.open "exec sp_department_zw " & temp_id & " " & " temp1_ID, conn,1,1

[hookee]

上面写错了，参数是数字的话:
rss.open "exec sp_department_zw " & temp_id & " " & temp1_ID, conn,1,1

[fhxy0010]

rs.open "select count(op_sp)as sum from oplist where op_ren='<%=session("employee_name")%>'and op_sp=4",conn,1,1 提示语句未结束?

[fhxy0010]

8楼,按照您的指示,还是有错误!

[hookee]

rs.open "select count(op_sp)as [sum] from oplist where op_ren='" & session("employee_name") & "' and op_sp=4",conn,1,1

[fhxy0010]

谢谢11楼,这个问题解决了!

[fhxy0010]

请问:
<% set rs=server.createobject("adodb.recordset")
rs.open "select count(op_sp)as [sum} from oplist where op_ren='"&session("employee_name")&"'and op_sp=4",conn,1,1
<font color=#000000>您有<%=rs("sum")>条待审记录</font>
%>
这个错误出在那里?

[fhxy0010]

13问题已解决!

[小河]

我也遇到过类似错误
原因是数据库的字段大小
如应该备注的改为文本