I have done this a million times, but am getting a BOF/EOF error ......

[Nancy]

and I can't get rid of it. I have a form on page one for the user to enter
their user name and password. On page two, these values are put through a
recordset where the proper record ID is picked and put into a session
variable based on these values.

If I put a known value into the query as a default, it works. If I put the
dummy "abc" and "xyz" values as default, I get BOF/EOF .. no data found
error even though I am entering known values into the form itself.

I have checked to make sure I am filtering the recordset correctly. I have
tried both Request.Form and just Request. I have tried changing POST to GET
and the query string in the header is correct. But it doesn't work.

Any thoughts? I have literally done this a thousand times .. and this is
1001. Unfortunately.

Thanks!
Nancy

The query:

<%
Dim rssetsession__MMColParam
rssetsession__MMColParam = "abc"
If (Request("txt_username") <> "") Then
rssetsession__MMColParam = Request("txt_username")
End If
%>
<%
Dim rssetsession__MMColParam2
rssetsession__MMColParam2 = "xyz"
If (Request("txt_password") <> "") Then
rssetsession__MMColParam2 = Request("txt_password")
End If
%>
<%
Dim rssetsession
Dim rssetsession_numRows

Set rssetsession = Server.CreateObject("ADODB.Recordset")
rssetsession.ActiveConnection = MM_conncfpea_STRING
rssetsession.Source = "SELECT EmployeeID FROM Employees WHERE UserName =
'" + Replace(rssetsession__MMColParam, "'", "''") + "' AND Password = '" +
Replace(rssetsession__MMColParam2, "'", "''") + "'"
rssetsession.CursorType = 0
rssetsession.CursorLocation = 2
rssetsession.LockType = 1
rssetsession.Open()

rssetsession_numRows = 0
%>