I have created a form with the code below
<form method=get action="showfilter-sql.asp">
Enter your text here:
<input type=text name="mytext" size="20"><br>
<input type=submit value="send info">
<input type=reset>
</form>
I want to filter the records of my access db
but whatever I enter in the search field the message "There are no records that matches your search" is shown
what is the problem???????

so this page:
<%@ language=vbscript %>
<% option explicit %>

<%
dim objConn
dim objConn
set objConn=server.createobject("Adodb.connection")
objConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("fpdb\satconcepts.mdb") & ";"
objConn.open
dim strMytext
strMytext=trim(request("Mytext"))
dim strSql
strSql="select term from sat where term= ' " & strMytext & "%' "
dim objRs
set objRs=server.createobject("adodb.recordset")
objrs.open strsql,objConn
if objRs.EOF then
response.write "There are no records that matches your search"
else
Do while not objRs.EOF
response.write "<b>" & objrs("term") & "</b><br>"
response.write "<b>" & objrs("definition") & "</b><br>"
objRs.movenext
loop
end if
objRs.close
set objrs=nothing
objconn.close
set objconn=nothing
%>

Well,
I suppose that an error occurs here:
If you use "%" I suppose that you want to display all records matching the form field's value pattern, so you have to use LIKE operator instead of "=".
Or, remove "%" if you want to display records matching exact value on the form field.

One more thing - in your SQL statement you retreive only one column named term, and objrs("definition") value cannot exist.


...but the Soon is eclipsed by the Moon