i'm not geting any due to which u have specified

i'm geting the from the line

"do while not rs.eof"

its not checking the end of file, then more over i'm geting the result while passing integer value than passing string value, but i need to get the count of the string value in the database based on the value which i'm passing through text field

so plz hlp me to rectify the error

thanks in advance

with regards,