AI智能
改变未来

哪个大侠帮我看一下怎么在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——————————————————^

赞(0) 打赏
未经允许不得转载:爱站程序员基地 » 哪个大侠帮我看一下怎么在PL/SQL中查询oracle数据库成功了,怎么加到ASP中就不成功?