cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1423
Views
0
Helpful
1
Replies

ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

nkhater
Beginner
Beginner

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, he is saying " I am not returning data",

I am not sure why I am not returning data, other wallboards like Tenox and ucguru are working fine, using exactly the same informix ODBC configs

The the error is below the code:

<!DOCTYPE html>

<html>

<!---------------------------------->

<!-- Created VOIPMonkey                                -->

<!---------------------------------->

<!--#include file="./parameters.cfg"-->

<%

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

%>

<head>

<meta http-equiv="Refresh" content="<%=RefreshTime%>;">

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title><%=PageTitle%></title>

<link type="text/css" href="../css/wallboard.css" rel="stylesheet" />

<script type="text/javascript" src="../js/jquery-1.6.2.min.js"></script>

<script type="text/javascript" src="../js/Wallboard.js"></script>

<script type="text/javascript">

// 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>

</head>

<body>

<div id="container">

<div id="main_content">

<div id="lia">

<h2>Logged In Agents</h2>

<h1><%=RS("LoggedInAgents")%></h1>

</div>

<div id="at">

<h2>Average Talk</h2>

<h1><%=RS("ConvAvgTalkDuration")%></h1>

</div>

<div id="lt">

<h2>Longest Talk</h2>

<h1><%=RS("ConvLongestTalkDuration")%></h1>

</div>

<div></div>

<div id="aa">

<h2>Available Agents</h2>

<h1><%=RS("AvailableAgents")%></h1>

</div>

<div id="aw">

<h2>Average Wait</h2>

<h1><%=RS("ConvAvgWaitDuration")%></h1>

</div>

<div id="lw">

<h2>Longest Wait</h2>

<h1><%=RS("ConvLongestWaitDuration")%></h1>

</div>

<div></div>

<div id="ta">

<h2>Talking Agents</h2>

<h1><%=RS("TalkingAgents")%></h1>

</div>

<div id="oc">

<h2>Oldest Contact</h2>

<h1><%=RS("ConvOldestContact")%></h1>

</div>

<div id="ch">

<h2>Calls Handled</h2>

<h1><%=RS("CallsHandled")%></h1>

</div>

<div></div>

<div id="cw">

<h2>Calls Waiting</h2>

<h1><%=RS("CallsWaiting")%></h1>

</div>

<div id="tm">

<h2><%=RS("csqname")%></h2>

<h1>

<%

sOffset = +0 'The time offset from GMT at the server

cTime = i + sOffset

tDiff = (DateAdd("h",cTime,Now))

Response.write FormatDateTime(tDiff,3)

%>

</h1>

</div>

<div id="ca">

<h2>Calls Abandoned</h2>

<h1><%=RS("CallsAbandoned")%></h1>

</div>

<div></div>

</div>

<!-- End of Main Content Div -->

</div>

<!-- End of Container Div -->

</body>

<%

RS.Close

cn.Close

%>

</html>

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

1 Reply 1

Graham Old
Rising star
Rising star

Are the other wallboards like Tenox and ucguru working against this CCX server or a different CCX

All of your setup is hidden in the parameters.cfg can you post the contents of that.

Is this a HA system?

Graham

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers