Code to generate passwords on our site used to work and now it doesn’t.

I get an error message that reads:

ADODB.Field error ‘800a0bcd’

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/ASP/ReacherSubmit.asp, line 103

I believe line 103 is intReacherID = rs.Fields( “ReacherID” )

Here’s the code:

set RS = MyConn.Execute(MySQL)

MySQL = “SELECT ReacherID FROM Reachers WHERE ReacherFirstName='”& strReacherFirstName &”‘ AND ReacherLastName='”& strReacherLastName &”‘ AND Title='”& strTitle &”‘ AND BuildingName='”& strBuildingName &”‘ AND Address1='”& strAddress1 &”‘ AND Address2='”& strAddress2 &”‘ AND City='”& strCity &”‘ AND State='”& strState &”‘ AND Zip='”& strZip &”‘ AND email='”& stremail &”‘ AND AccountOpened={fn now()} AND SkillLevel=”& bytSkillLevel &”;”

Set rs = Server.CreateObject( “adodb.recordset” )

‘Response.Write( MySQL & “<BR>” )

rs.Open MySQL, MyConn

intReacherID = rs.Fields( “ReacherID” )

Response.Cookies( “FACT_ReacherID” ) = intReacherID

MySQL = “INSERT INTO Users (initial_user_name, initial_password, user_type, reacher_id ) “

MySQL = MySQL & “VALUES( ‘” & Request.Cookies( “FACT_theUserID” ) & “‘, ‘” & Request.Cookies( “FACT_Password” ) & “‘, 2, ” & intReacherID & “)”

Response.Write( MySQL & “<BR>”)

set rs = MyConn.Execute( MySQL )

‘rs.Close

MyConn.Close

We tried lots of punctuation tweaks, single quotes, double, etc.

Any idea what is going on?