UC知道asp 这样有错吗
来源：百度知道 编辑：UC知道 时间：2024/06/07 03:44:47
<%Sql = "Select Sum(y5) As Thesum from table204 where( baobiaoym="&baobiaoym&" )and( dm=21) and qyxx_id in (Select qyxx_id from table8 where (gmsbs="&gmsbs&" )and( bmdm='"&bmdm&"') and (baobiaoym="&baobiaoym&"))"
'response.Write "Sql="&Sql&"<br>"
Set LotusRs = Con.Execute(Sql)
if not LotusRs.EOF then
if IsNull(LotusRs("thesum")) or LotusRs("thesum")="" then
get_bm_all = 0
else
get_bm_all = Round(LotusRs("thesum"),2)
end if
else
get_bm_all = 0
end if%>
高手帮忙改正一下
'response.Write "Sql="&Sql&"<br>"
Set LotusRs = Con.Execute(Sql)
if not LotusRs.EOF then
if IsNull(LotusRs("thesum")) or LotusRs("thesum")="" then
get_bm_all = 0
else
get_bm_all = Round(LotusRs("thesum"),2)
end if
else
get_bm_all = 0
end if%>
高手帮忙改正一下
你不是用以下这个测试查看sql语法了吗
'response.Write "Sql="&Sql&"<br>"
你想知道 sql语句写的对不对可以这样做
response.write sql
把sql语句输出来,然后复制到 sql server 中的查询分析器中运行一下就ok了吗，错还是对就可以看到啦
sql上面代码有这行吧
set LotusRs=server.CreateObject("adodb.recordset")
晕