Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ASP query not returning current data
I have an application written in ASP. I'm moving it over to Oracle.
For some reason my queries don't return new data. I can run an insert
query through SQL+. But when I try to retreive the data through server
side code, I get nothing even though I know the data is there - 7
records. This code returns zero records or if I try to out fields,
nothing.
Here some sample code.
Set objConn = Server.CreateObject("ADODB.Connection")
OpenNewConnection(objConn)
set rs = Server.CreateObject("ADODB.Recordset") rs.CursorLocation = adUseClient rs.CursorType = adOpenStatic rs.LockType = adLockBatchOptimistic rs.Open "SELECT count(*) as cnt from survey_instance", objConn While Not rs.EOF response.write("cnt : " & rs("cnt") & "<br>") rs.MoveNext WendReceived on Sun Nov 10 2002 - 22:46:14 CST