我找不出语句的错误！

[doudouli678]

麻烦高手老师解答我的问题
<% xn=trim(request.form("xn"))
xq=trim(request.form("xq"))
bj=trim(request.form("bj"))
km=trim(request.form("km"))
Set conn=Server.CreateObject("ADODB.Connection")
Set Rs=Server.CreateObject("ADODB.Recordset")
conn.open"DSN=myconn;UID=sa;PWD=asp123"
sql="select count(*),SUM(cj),AVG(cj),MAX(cj),MIN(cj),"
sql=sql & "sum(iif(cj>=90,1,0)),"
sql=sql & "sum(iif(cj>=80 and cj <=89,1,0)),"
sql=sql & "sum(iif(cj>=70 and cj<=79,1,0)),"
sql=sql & "sum(iif(cj>=60 and cj<=69,1,0)),"
sql=sql & "sum(iif(cj<60,1,0)),"
sql=sql & "sum(iif(cj>=60,1,0))"
sql=sql & " from stu_score"
sql=sql & " where xn='"&xn&"' and xq='"&xq&"' and bj='"&bj&"'"
sql=sql & " and km='"&km&"'"
rs.open sql,conn,3,1
%>

错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: '>' 附近有语法错误。
/total2.asp, 第 20 行

[子陌红尘]

ACCESS？SQL Server不支持IIF()函数，改成用CASE WHEN的模式再试。

[doudouli678]

谢谢，说得具体点

[子陌红尘]

for example:

sum(iif(cj>=90,1,0))  ==>  sum(case when cj>=90 then 1 else 0 end)

[lg3605119]

sum(iif(cj>=80 and cj <=89,1,0))

改成

sum(case when cj>80 and cj<=89 then 1 else 0 end)


别的照着修改就行

[doudouli678]

非常感谢！接分了

[doudouli678]

同时也谢谢４楼高手，下次给你分