帮我看看这个语句吧？怎么不能模糊查询呢？

[yurui]

sql = "select * from shangpin where　shangpinzhonglei = "&zl&" and shanpin like '"&sp&"'"

ＺＬ是用数字型
ＳＨＡＮＧＰＩＮ是文本型
当输入的ＳＨＡＮＧＰＩＮ和数据库中完全匹配时才可以显示，否则就出错。
出错信息如下：ADODB.Recordset 错误 '800a0bcd'
BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录。

/dw/search2.asp，行32

[lihua9666]

缺少“%”
sql = "select * from shangpin where　shangpinzhonglei = "&zl&" and shanpin like '%"&sp&"%'"

[wshzhi]

sql = "select * from shangpin where　shangpinzhonglei = "&zl&" and shanpin like '%"&sp&"%'"

[lbd8848]

sql = "select * from shangpin where　shangpinzhonglei = "&zl&" and shanpin like '%"&sp&"%'"

[bws]

写为：and shanpin like '%"&sp&"%'" 就可以了。另外，建议增加类似以下判断再操作：
if not [sql的执行结果].EOF then ... end if

[jacklinchen]

这句错了，这样：
sql = "select * from shangpin where　shangpinzhonglei = "&zl&" and shanpin like '%"&sp&"%'"

[swich]

SQL:
sql = "select * from shangpin where　shangpinzhonglei = "&zl&" and shanpin like '%"&sp&"%'"

ACCESS:
sql = "select * from shangpin where　shangpinzhonglei = "&zl&" and shanpin like '#"&sp&"#'"

[xiantao123]

sql = "select * from shangpin where　shangpinzhonglei = "&zl&" and shanpin like '%"&sp&"%'"
肯定是这样的。

[xieyj]

提示的是没有找到记录，模糊查询请使用：
sql = "select * from shangpin where　shangpinzhonglei = "&zl&" and shanpin like '%"&sp&"%'"

[潜水的鱼]

晕,~~~~~~~~~~楼up

没想到这么多人在接分

来迟了,干脆再来下

sql = "select * from shangpin where　shangpinzhonglei = "&zl&" and shanpin like '%"&sp&"%'"

^_^

[潜水的鱼]

晕~~没想到楼%

这么多个在接分,偶也插一腿

sql = "select * from shangpin where　shangpinzhonglei = "&zl&" and shanpin like '%"&sp&"%'"

^_^

[zjh13226]

少了%

[yidixiaoyu]

sql = "select * from shangpin where　shangpinzhonglei = "&zl&" and shanpin like '%"&sp&"%'"

[xiejunhua]

拾点分

[blueice2002]

sql = "select * from shangpin where　shangpinzhonglei = "&zl&" and shanpin like '%"&sp&"%'"


结帖吧，老大