Question

ASP中SQL查询语句带多个变量的写法怎样写(多字段模糊查询)?

这是多个变量组合的模糊查询,写出了条件后不知道怎样写执行语句~试了多次还是不行....

if ProduceName<>"" then nameStr=" and ProduceName="&ProduceName&""

if XingHao<>"" then XingHaoStr=" and XingHao="&XingHao&""

if Time1<>"" and Time2<>"" then TimeStr=" and date=between '#"&Time1&"#' and '#"&Time2&"#'"
(后面的省略)

我试过下面两个写法,都是不行,请问正确的怎样写?我的错在哪?
set rs=conn.execute("select * from '"&biao&"' where 1=1 '"&nameStr&"' '"&XingHaoStr&"' '"&TimeStr&"'") '(这里的变量biao是看用户选择对那个表进行查询)

sql="select * from "&biao&" where 1=1" & nameStr & XingHaoStr & TimeStr
conn.execute(sql)

Answer 1

select * from "&biao&" where [nameStr在表中对应的列]='" & nameStr & "' [XingHaoStr在表中对应的列]='" & XingHaoStr & "[TimeStr在表中对应的列]=" & TimeStr

Answer 2

ha~~三楼的改对了地方~可是还差一处~~

if Time1<>"" and Time2<>"" then TimeStr=" and date=between #"&Time1&"# and #"&Time2&"#"

这里的between前不是等号,是空格...哈哈~~我看出来了~~

Answer 3

加上单引号
if ProduceName<>"" then nameStr=" and ProduceName='"&ProduceName&"'"

if XingHao<>"" then XingHaoStr=" and XingHao='"&XingHao&"'"

去掉单引号
if Time1<>"" and Time2<>"" then TimeStr=" and date=between #"&Time1&"# and #"&Time2&"#"

Answer 4

多几个LIKE 。。