Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ASP query not returning current data

ASP query not returning current data

From: Rich D <rdalfonso_at_nyc.rr.com>
Date: 10 Nov 2002 20:46:14 -0800
Message-ID: <196cd325.0211102046.252da3fd@posting.google.com>


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 
  	Wend
Received on Sun Nov 10 2002 - 22:46:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US