Hey gang. I have a form to select multiple names.
The problem I am having, is when it gets to the asp page. If I click 1 name,
it will process. But multiple names gives me an error:
Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record.
/GIG/ladder/reportasp2_new.asp, line 53
that line's code is
set rsID2 = conn.execute ("select total_score from rounds where username =
'" & var1 & "'")
var11 = rsID2.fields.item("total_score").value
what appears to be happening, is it isn't picking up all the names.
on the asp page, i begin the code with this.
For Each Item In Request.QueryString("username") and have a NEXT at the end
of the code.
this is using access db
i don't know what i am missing
If i do a response.write it gives the names twice for some reason.
i made a dummy page, just to see how the names are getting sent, but they
are getting repeated. this is the code
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open (MM_connection_STRING)
%>
<%
For Each Item In Request.QueryString("username")
var1 = Request.querystring("username") 'first player
var2 = Request.querystring("username1") 'person reporting
response.write var1
if UCASE(var1) = UCASE(var2) then
response.redirect "report_self.asp"
else
end if
Next
Conn.Close
Set Conn = Nothing
'response.redirect "current.asp"
%>
test it here to see what i mean
http://www.gig-gamers.com/GIG/ladder/report_new.asp
can anyone help??