ASP中SQL查询语句带多个变量的写法怎样写(多字段模糊查询)?
来源:百度知道 编辑:UC知道 时间:2024/05/10 14:09:36
这是多个变量组合的模糊查询,写出了条件后不知道怎样写执行语句~试了多次还是不行....
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)
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)
ha~~三楼的改对了地方~可是还差一处~~
if Time1<>"" and Time2<>"" then TimeStr=" and date=between #"&Time1&"# and #"&Time2&"#"
这里的between前不是等号,是空格...哈哈~~我看出来了~~
加上单引号
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&"#"
select * from "&biao&" where [nameStr在表中对应的列]='" & nameStr & "' [XingHaoStr在表中对应的列]='" & XingHaoStr & "[TimeStr在表中对应的列]=" & TimeStr
多几个LIKE 。。