if s1 ="" and s3 = "" and s4 = ""then sql="select * from r[edbook] " else sql="select * from [redbook] where (xl-name like '%"&s1&"%' or xl-xs like '%"&s3&"%' or xl-sec like '%"&s4&"%') and language="&language&" order by id" end if rs.open sql,conn,1,1 %>
错误说明:(数据类型不匹配或表/字段错误或处于编辑状态,或不存在于conn打开的数据库中)
那应该是你WHERE 里面的类型可能不对,是不是都已经是字符型了?
sql="select * from redbook where ([xl-name] like '%"&s1&"%' or [xl-xs] like '%"&s3&"%' or [xl-sec] like '%"&s4&"%') and language="&language&" order by id"列名中如果包含"-",必须要用[]括起来.
s1=request("s1")
s3=request("s3")
s4=request("s4")
if s1 ="" and s3 = "" and s4 = ""then
sql="select * from r[edbook] "
else
sql="select * from [redbook] where (xl-name like '%"&s1&"%' or xl-xs like '%"&s3&"%' or xl-sec like '%"&s4&"%') and language="&language&" order by id"
end if
rs.open sql,conn,1,1
%>