大家帮忙看一下这个sql构造怎么老报错 急用!!!!!!!!!!!!
str1 = "select * from stair where 1=3 and "
str2 = "(name like '"&searchkey&"'"
str3 = " and wuye like '"&wuye&"'"
str4 = " and price>"&price1&" and price=<"&price2&")"
sql = str1&str2&str3&str4
set rs=conn.Execute(sql)
大家帮忙看一下这个sql构造怎么老报错
错误类型:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
/tool/lookbuilding/sousuo.asp, 第 42 行
42 行:set rs=conn.Execute(sql)
急等谢谢 各位大虾 要不今天的任务又没有完成!!!!!!!!!!!!