<% sql=\”select x.nsrsbh,x.nsrmc,x.swdjblx_dm,x.swdjzlx_dm
from dj_nsrxx x,(select nsrdzdah,sum(se) as se
from sb_zsxx
where to_char(jkfsrq,\’yyyy-mm-dd\’) between \’2007-01-01\’ and
\’2007-12-31\’ and hy_dm between \’0100\’ and \’4600\’
group by nsrdzdah) y
where y.se > 500000 and x.nsrdzdah= y.nsrdzdah and x.swdjblx_dm <> \’8\’\”
set rs=server.createobject(\”adodb.recordset\”)
rs.open sql,objConn,1,1
%>
=====================红字部分如果是简单的查询语句就成功了的
Microsoft VBScript 编译器错误 错误 \’800a03f6\’
缺少 \’End\’
/iisHelp/common/500-100.asp,行242
Microsoft VBScript 编译器错误
错误 \’800a0409\’
未结束的字符串常量
/conn.asp,行8 sql=\”select x.nsrsbh,x.nsrmc,x.swdjblx_dm,x.swdjzlx_dm——————————————————^