Question

高手来看看 asp 模糊查询问题

<%
title=request.form("title")
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("sky.mdb")
exec="select * from base where title='"+title+"'"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
请问怎么才能实现模糊查询,另外把中间的
exec="select * from base where title='"+title+"'换成
exec="select * from base where title like'"&title&"' order by id desc "
错误提示为:

ODBC 驱动程序不支持所需的属性。

Answer 1

exec="select * from base where title like '%" & title & "%'"