下面这条语句哪有问题

来源：百度知道 编辑：UC知道 时间：2024/05/03 14:50:24
rs.open "SELECT*FORM list where title and word like '%'&request.form("word")&'%'",MyCon,adOpenStatie
这条语句哪块有问题？为什么老是提示为无效字符？错误代码为：错误 '800a0408'

rs.open "SELECT * FORM list where title and word like %"&request.form("word")&"%",MyCon,adOpenStatie

'TITLE没有指定数据

rs.open "SELECT * FORM [list] where title='"&title&"' and word like '%'&request.form("word")&'%'",MyCon,1,1

'复合查询
rs.open "SELECT * FORM [list] where title like '%'&request.form("word")&'%' or word like '%'&request.form("word")&'%'",MyCon,1,1

如果是用的access数据库，把and换成or就可以了：
rs.open "SELECT * FORM list where title or word like '%'&request.form("word")&'%'",MyCon,adOpenStatie

如果是mssql数据库的话就要这样写：
rs.open "SELECT * FORM list where title like '%'&request.form("word")&'%' or word like '%'&request.form("word")&'%'",MyCon,adOpenStatie

like语句错了
，改为：
rs.open &qu