if request("nclass")="" and request("sheng")="" and request("mj")="" then
response.redirect "main.asp"
end if

if request("sheng")<>"" then
sheng=request("sheng")
end if

if request("mj")<>"" then
mj=split(request("mj"),"-")
mjs=Cint(mj(0))
mjb=Cint(mj(1))
end if
尤其是下面的代码,是通过组合来查询的,数值型变量如何表示呢,例如:xmj>=mjs and xmj<=mjb,变量要加什么符号吗?

if request("sheng")<>"" and request("mj")<>"" then
sql="SELECT nclass, shengname, xdata, xid, xinfo, xqy FROM v_workshop where nclassid="&nclassid&" and shengid="&sheng&" and xmj>=mjs and xmj<=mjb"
end if

if request("sheng")="" and request("mj")<>"" then
sql="SELECT nclass, shengname, xdata, xid, xinfo, xqy FROM v_workshop where nclassid="&nclassid&" and shengid="&sheng&""
end if

if request("sheng")<>"" and request("mj")="" then
sql="SELECT nclass, shengname, xdata, xid, xinfo, xqy FROM v_workshop where nclassid="&nclassid&" and xmj>=mjs and xmj<=mjb"
end if

输出SQL看看就明白了，那地方不对改哪！

要注意的是：
数据库中数字型字段不需要加单引号，字符型和日期型要加单引号

Microsoft JET Database Engine 错误 '80040e14'

语法错误 (操作符丢失) 在查询表达式 'nclassid= and shengid= and xmj>= and xmj<=' 中。

/factory/main/list_search.asp，行 40


请高手帮忙分析一下哦

错误不是已经很明白地告诉你了吗

sql="SELECT nclass, shengname, xdata, xid, xinfo, xqy FROM v_workshop where nclassid="&nclassid&" and shengid="&sheng&" and xmj>=mjs and xmj<=mjb"
红字的变量可能没有值