First forgive me about my english ! I'm Vietnamse
I have two page in my site. The first page is

<Form action="SearchResult.Asp" method="GET">
  <input type="Text" name="txtValue">
  <Input type="Submit" Value="Search" name="cmdSearch">
</Form>

The second page is:SearchResult.Asp

Set Cn=Server.createObject("ADODB.Connection")
    Set Rs=Server.CreatOject("ADODB.Recordset")

   Cn.Open ("DSN=mydatabase")
   Dim Value
       Value=Request.Querystring("txtValue")
      Rs.Open "Select * from myTable where myFilde = '"& Value&"'",1,2

I want the Pagesize in the second page but i get the following error
The Recordset object is Either .BOE or EOF

What do I have to do to fixed this problem and where the code is ?
Thank for your help !

I think you got to change you select statement. This wont be giving you any result, when you search for "test" where the word "test" is present somewhere within the field value. So change it as follows.

Select * from myTable where myFilde like '%"& Value & "%'"

This should work.

Cheers!

-Vijay G