I call this code from a page via ajax and it does not pick up newly added records just the same old records over and over!

This is my server side script:

<!-- #include file = "DSN.asp" -->
<%
Set rs=Server.CreateObject("ADODB.RecordSet")
rs.ActiveConnection = conn
rs.open ("SELECT top 1 time FROM calls INNER JOIN cliente INNER JOIN p1 ON cliente.id_cli = p1.clie INNER JOIN p2 ON p1.id_p1 = p2.p1 INNER JOIN p3 ON p2.id_p2 = p3.p2 INNER JOIN p4 ON p3.id_p3 = p4.p3 ON calls.number = p4.c2 WHERE(cliente.id_cli = 30) order by time desc")
Resp = rs.fields("time")
rs.close
Set rs = nothing
conn.close 
Response.Write(Resp)
%>

When I go to this script via url the data is fresh and it poicks up any changes, however when I call it from the client it returns old data, it does not pick up new records, what is going on?

P.S. MSSQL Database.

I don't think it will give you different output while calling from client side. I think you are not clearing prev data.. Can I see the client side code ?

Try:

setting the cursorlocation to be clientside (default is serverside)
rs.cursorlocation = adUseClient
http://www.devguru.com/technologies/ado/8650.asp

and a dynamic CursorType
rs.cursortype = adOpenKeyset
http://www.devguru.com/technologies/ado/8651.asp

set these before opening the recordset.

I have tried every cursor under the sun and same result, script is queying data not client. but here is clientside script.

 
function Refresh()
{
var xmlHttp;
try
{ // Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{ // Internet Explorer
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
try
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
catch (e)
{
alert("Your browser does not support AJAX!");
return false;
}
}
}
xmlHttp.onreadystatechange=function()
{
if(xmlHttp.readyState==4)
{
var t=setTimeout("Refresh()",10000);
var Rsp=xmlHttp.responseText;
alert(Tst)
alert(Rsp)
if(Tst != Rsp)
{
Tst = Rsp;
window.location.href="b_monito.asp?"+Rsp;
}
}
}
xmlHttp.open("Get","update.asp",true);
xmlHttp.send(null);
}

FYI, Response.Expires = -1000