大家帮忙看一下这个sql构造怎么老报错 急用！！！！！！！！！！！！

[princekey]

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)
急等谢谢 各位大虾 要不今天的任务又没有完成！！！！！！！！！！！！

[lbd8848]

使用
response.write sql
显示出来看看
字段名是否正确
price1,price2是否为空??

[princekey]

都是正确的

[lbd8848]

再试一下语句能否在sqlserver的"查询分析器"执行
如果可以,那问题就出在conn上了

[baby21st]

str2 = "(name like '"&searchkey&"'"
--------^
str4 = " and price>"&price1&" and price=<"&price2&")"
---------------------------------------------------^

把这()去掉看看

[princekey]

rs.open "select * from stair",conn,1,1
可是我打开这个就好的

[OnlyVB]

改成：
str2 = "(name like '%"&searchkey&"%'"
str3 = " and wuye like '%"&wuye&"%'"

[lbd8848]

那问题,还是在sql语句上,price是什么类型
这样试试:
str1 = "select * from stair where 1=3 and "
str2 = "(name like '%"&searchkey&"%'"
str3 = " and wuye like '%"&wuye&"%'"
str4 = " and price>"&price1&" and price=<"&price2&")"

[princekey]

不可以 啊 prince是数字int

[lbd8848]

1.where 1=3 ?? 做什么用 1是不是l(L) ?
2.既然条件间都用and 连接那()有什么作用?

[princekey]

我现在
response.write aql
得到的是select * from stair where name like '国' and wuye like '高档公寓' and avg_price>2000 and avg_price=<2500
但还是同样的错误

[lbd8848]

name -> [name] 试试

[princekey]

不可以 哎 晕

[lbd8848]

那在sqlserver的"查询分析器"能不能执行?

[61]

sql = "select * from stair where 1=3 and name like '"&searchkey&"' and wuye like '"&wuye&"' and (price between "&price1&" and "&price2&")"
set rs=server.CreateObject ("adodb.recordset")
on error resume next
rs.Open sql,Conn,1,3
response.write err.description

[princekey]

哈哈 搞定谢谢 加分

[一个老程序袁]

avg_price=<2500 ??
=>
avg_price<=2500