How can i compare the record count?
Actually i tried as per your suggestion,i created one new page and wrote script for counting the records i got it at the same time i stored in one more variable also.using meta tag i made the page to get refreshed each 5 sec.i achieved.
now i struck up in comparision of both variables.Also i have doubt when first var count change means immediately it changes other variable count also.how to do that?please i am not that expert in asp.pls expain.
- <%
-
dim strCon
-
strCon = "DBQ=C:\Inetpub\wwwroot\manage\ivr.mdb; DRIVER=Microsoft Access Driver (*.mdb)"
-
Set objConn = Server.CreateObject ("ADODB.Connection")
-
objConn.open strCon
-
Set Rec = objConn.execute("Select count(*) from Itemworkorder")
-
curcount=Rec
-
'if cucount>rec then
-
'window.open(message.asp, windowname, 'width=450,height=300,scrollbars=yes');
-
'end if
-
%>
-
-
<html>
-
<head>
-
<meta http-equiv="refresh" content="5">
-
</head>
-
<body>
-
There are <%= Rec(0) %> records in the table.<%=curcount(0) %>
-
</body>
-
</html>
-
this is actually separate file where i need to include this coding in login page or where i am descriping and displaying the particular table content that page.
Actually i want whoever login this url.in any terminal one small addition record this pop up should reflect in all the systems as it is showing one new complaint received.
pls help
218
