2008-10-06 09:20:23 / ASP & Access & SQL Server 后台编程讨论版
两个数据库employee,employee_gd ，employee,employee_gd 结构都一样,我查询的时候用UNION ALL就可以，修改就不可以dim id,pp,rs,sql,vid=request("id")if id"" thenpp=ubound(split(id,","))+1for v=1 to ppid=request("id")(v)set rs=server.createobject("adodb.recordset")sql="SELECT CheckNGCounter,id FROM employee.dbo.employee UNION ALL SELECT CheckNGCounter,id FROMemployee_china.dbo.employee where id='"&id&"'"rs.open sql,DBconn,1,3rs("CheckNGCounter")=0r
查看(241)
评论(0)
