strSQL = "SELECT SUM(an.Total_Number) AS Total_Number1 " & _
"FROM GBW_OTHIST an WITH (NOLOCK) " & _
"WHERE an.Staff_No = '" & Staff_No & "'" & lngWhere1 & _
"UNION " & _
"SELECT SUM(bn.Total_Number) AS Total_Number2 " & _
"FROM GBW_OTTRAN bn " & _
"WHERE bn.Staff_No = '" & Staff_No & "'" & _
"AND bn.Pass1 = 'Y' " & _
"AND bn.Pass2 = 'Y' " & lngWhere2
Res0.open strSQL, Conn, 1, 1'//前提表里面有记录
response.write Res0("Total_Number1")
response.write Res0("Total_Number2")
'//第二个response.write时报错:
ADODB.Recordset error '800a0cc1'
项目在所需的名称或序数中未被发现。 请问是哪里错了,如果要达到我所要的结果应该如何做啊....谢谢!
不好意思啊,小北暂时没分,等以后有的时候补上,请前辈帮忙...
"FROM GBW_OTHIST an WITH (NOLOCK) " & _
"WHERE an.Staff_No = '" & Staff_No & "'" & lngWhere1 & _
"UNION " & _
"SELECT SUM(bn.Total_Number) AS Total_Number2 " & _
"FROM GBW_OTTRAN bn " & _
"WHERE bn.Staff_No = '" & Staff_No & "'" & _
"AND bn.Pass1 = 'Y' " & _
"AND bn.Pass2 = 'Y' " & lngWhere2
Res0.open strSQL, Conn, 1, 1'//前提表里面有记录
response.write Res0("Total_Number1")
response.write Res0("Total_Number2")
'//第二个response.write时报错:
ADODB.Recordset error '800a0cc1'
项目在所需的名称或序数中未被发现。 请问是哪里错了,如果要达到我所要的结果应该如何做啊....谢谢!
不好意思啊,小北暂时没分,等以后有的时候补上,请前辈帮忙...
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货