哪个大侠帮我看一下怎么在PL/SQL中查询oracle数据库成功了，怎么加到ASP中就不成功？

<% 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
------------------------------------------------------^