set rs=server.createobject("adodb.recordset")
sql="select id,biaoti from data where dalei="&dalei& "and xiaolei="&xiaolei& "and biaoti like '%"&keyword&"%'"
rs.open sql,conn,1,1
提示最后一行“rs.open sql,conn,1,1”错了，我不知错在哪里？请大家帮忙看看！
---------------------------------------------------------------
sql="select id,biaoti from data where dalei="&dalei& "and xiaolei="&xiaolei& "and biaoti like '%"&keyword&"%'"
response.write sql
response.end
'rs.open sql,conn,1,1
把输出的结果放到sql查询分析器里运行，就知道错误是什么了。
---------------------------------------------------------------
sql="select id,biaoti from data where dalei="&dalei& "and xiaolei="&xiaolei& "and biaoti like '%"&keyword&"%'"
你的dalei 和 xiaolei 字段是什么格式的
如果是文本
要改成这样
sql="select id,biaoti from data where dalei='"&dalei& "' and xiaolei='"&xiaolei& "' and biaoti like '%"&keyword&"%'"
---------------------------------------------------------------
sql="select id,biaoti from data where dalei="&dalei& "and xiaolei="&xiaolei& "and biaoti like '%"&keyword&"%'"
你的dalei 和 xiaolei 字段是什么格式的
如果是文本
要改成这样
sql="select id,biaoti from data where dalei='"+dalei+ "' and xiaolei='"+xiaolei+ "' and biaoti like '%"+keyword+"%'"