asp多条件查询问题

来源：百度知道 编辑：UC知道 时间：2024/06/20 06:24:58
rs2.open"select * from szfw where start_time between #"&r1&"# and #"&r2&"# and zhj between "&r3&" and "&r4&" and jd between "&r5&" and "&r6&"and wd between "&r7&" and "&r8&"and place='"&r9&"'",conn,1,3
其中r1-r9是获取的值，但运行中老出错，说是语法错误（操作符丢失）
还请高手能够帮我看看，到底是那里出了问题。本人正在做网站，急！！！！

sql="select * from szfw where not(id is null)"
if trim(r1)<>"" and trim(r2)<>"" then
sql=sql+" and start_time between #"&r1&"# and #"&r2&"#"
end if
if trim(r3)<>"" and trim(r4)<>"" then
sql=sql+" and zhj between "&r3&" and "&r4&""
end if
if trim(r5)<>"" and trim(r6)<>"" then
sql=sql+" and jd between "&r5&" and "&r6&""
end if
if trim(r7)<>"" and trim(r8)<>"" then
sql=sql+" and wd between "&r7&" and "&r8&""
end if
if trim(r9)<>"" then
sql=sql+" and place='"&r9&"'"
end if
rs2.open sql,conn,1,3

如果你在做网站的话，而且SQL语句教多，建议你使用存储过程实现。