在SQLSERVER中正常但是在ASP中不正常解决方法
在SQLSERVER中正常但是在ASP中不正常
SQL语句是:select sum(rzbf) rzbf,sum(ysbf) ysbf,sum(ssbf) ssbf from (select sum(hjbf) rzbf,sum(hjysbf) ysbf,sum(hjssbf) ssbf from h_cbtz where 1=1 and jbr in ( '005011 ') group by polno having sum(hjysbf)!=0 and max(jfrq) between '9/11/2006 ' and '10/11/2006 ')
在SQLSERVER中尝试运行没有任何问题,但是在ASP中运行后却报
Microsoft OLE DB Provider for SQL Server 错误 '80040e14 '
Line 1: Incorrect syntax near ') '.
/tj/yshou/yshou.asp,行 154
错误,请大家帮忙看看,ASP语句没有问题,我把SQL换成
select sum(hjbf) rzbf,sum(hjysbf) ysbf,sum(hjssbf) ssbf from h_cbtz where 1=1 and jbr in ( '005011 ') group by polno having sum(hjysbf)!=0 and max(jfrq) between '9/11/2006 ' and '10/11/2006 '
就很正常(当然这个结果不是我想要的结果,我想要的效果是上条SQL的执行结果),真奇怪,请大家帮忙,谢谢。
------解决方案--------------------
你这两个sql并不是同一样. 错误的原因是子查询没有指定别名. try: select sum(AA.rzbf) rzbf,sum(AA.ysbf) ysbf,sum(AA.ssbf) ssbf from ( select sum(hjbf) rzbf, sum(hjysbf) ysbf, sum(hjssbf) ssbf from h_cbtz where 1=1 and jbr in ( '005011 ') group by polno having sum(hjysbf)!=0 and max(jfrq) between '9/11/2006 ' and '10/11/2006 ') AS AA
SQL语句是:select sum(rzbf) rzbf,sum(ysbf) ysbf,sum(ssbf) ssbf from (select sum(hjbf) rzbf,sum(hjysbf) ysbf,sum(hjssbf) ssbf from h_cbtz where 1=1 and jbr in ( '005011 ') group by polno having sum(hjysbf)!=0 and max(jfrq) between '9/11/2006 ' and '10/11/2006 ')
在SQLSERVER中尝试运行没有任何问题,但是在ASP中运行后却报
Microsoft OLE DB Provider for SQL Server 错误 '80040e14 '
Line 1: Incorrect syntax near ') '.
/tj/yshou/yshou.asp,行 154
错误,请大家帮忙看看,ASP语句没有问题,我把SQL换成
select sum(hjbf) rzbf,sum(hjysbf) ysbf,sum(hjssbf) ssbf from h_cbtz where 1=1 and jbr in ( '005011 ') group by polno having sum(hjysbf)!=0 and max(jfrq) between '9/11/2006 ' and '10/11/2006 '
就很正常(当然这个结果不是我想要的结果,我想要的效果是上条SQL的执行结果),真奇怪,请大家帮忙,谢谢。
------解决方案--------------------
你这两个sql并不是同一样. 错误的原因是子查询没有指定别名. try: select sum(AA.rzbf) rzbf,sum(AA.ysbf) ysbf,sum(AA.ssbf) ssbf from ( select sum(hjbf) rzbf, sum(hjysbf) ysbf, sum(hjssbf) ssbf from h_cbtz where 1=1 and jbr in ( '005011 ') group by polno having sum(hjysbf)!=0 and max(jfrq) between '9/11/2006 ' and '10/11/2006 ') AS AA