Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True,

nkhaternkhater Washington DCMember Posts: 1

Can someone tell me what I have wrong in this code? This is a call center wallboard that I am using from VOIPMonkey website, so it is not my code; and I am not a developer, I tried contacting the author to no luck, the error is below the code:

<!DOCTYPE html>





<%

                WBConnect = "Dsn="& DSN &";" & _
                       "Host="& DBsource &";" & _
                       "Server="& ServerName &";" & _
                       "Service="& ServicePort &";" & _
                       "Protocol="& Protocol &";" & _
                       "Database="& DBdatabase &";" & _
                       "Uid="& DBuserID &";" & _
                       "Pwd="& DBpass &""

                Set cn = Server.CreateObject("ADODB.Connection")
                cn.ConnectionTimeout = Session("ConnectionTimeout")
                cn.CommandTimeout = Session("CommandTimeout")
                cn.open WBConnect

                Set SQLStmt = Server.CreateObject("ADODB.Command")
                Set RS = Server.CreateObject ("ADODB.Recordset")
                SQLStmt.CommandText = SQL_Command
                SQLStmt.CommandType = 1
                Set SQLStmt.ActiveConnection = cn
                RS.Open SQLStmt
                RS.MoveFirst

            %>


;">

<%=PageTitle%>




// DOM Ready !!
$(function(){
// Data Check and Div Change

        // Check Available Agents and set Display Colours
            CheckAvailableAgents(<%=RS("AvailableAgents")%>);

        // Check Logged In Agents and set Diaplay Colours
            CheckLoggedInAgents(<%=RS("LoggedInAgents")%>);

        // Check Calls Waiting and set Display Colours
            CheckCallsWaiting(<%=RS("CallsWaiting")%>);
        });
    </script>


Logged In Agents

<%=RS("LoggedInAgents")%>

Average Talk

<%=RS("ConvAvgTalkDuration")%>

Longest Talk

<%=RS("ConvLongestTalkDuration")%>

Available Agents

<%=RS("AvailableAgents")%>

Average Wait

<%=RS("ConvAvgWaitDuration")%>

Longest Wait

<%=RS("ConvLongestWaitDuration")%>

Talking Agents

<%=RS("TalkingAgents")%>

Oldest Contact

<%=RS("ConvOldestContact")%>

Calls Handled

<%=RS("CallsHandled")%>

Calls Waiting

<%=RS("CallsWaiting")%>

<%=RS("csqname")%>

<% sOffset = +0 'The time offset from GMT at the server cTime = i + sOffset tDiff = (DateAdd("h",cTime,Now)) Response.write FormatDateTime(tDiff,3) %>

Calls Abandoned

<%=RS("CallsAbandoned")%>

<!-- End of Container Div -->


<% RS.Close cn.Close %>


Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/wb/mainwb.asp, line 29

Sign In or Register to comment.