ASP数据库查询

 <%dim wh,idd
            idd = request.QueryString("tyid")
            wh =" where [id] ='"&idd&"'"
            set rs = fcn.getone("select * from type "&wh&" ")
             %>

代码如上,为何出错?

"错误类型：
Microsoft JET Database Engine (0x80040E07)
标准表达式中数据类型不匹配。"

tyid应该是数字吧

你改成

<%dim wh,idd
    idd = request.QueryString("tyid")
    wh =cint(idd)
    set rs = fcn.getone("select * from type where [id] ="&wh)
    %>

试试