12-30-2013 07:35 AM - edited 03-14-2019 12:55 PM
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
12-30-2013 12:50 PM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide