Tom pointed out that you might be connecting to the wrong scheme. Also you
don;t get a record count until you navigate the records. Just creating the
dynaset doesn't get the count; it just opens a cursor to the record set.
If you want to count then select count(*)....
Jim
"Frank" <yangcolt_at_hotmail.com> wrote in message
news:660ec58c.0210272216.59ccd7e4_at_posting.google.com...
> Please have a look at the following ASP code. RecordCount is ALWAYS 0.
> OraDynaset.BOF and OraDynaset.EOF are all ALWAYS True. Could anyone
> tell me why ?
>
>
> This is just a copy from the sample code. and I am 100% sure the
> database can be connected successfully.
>
> Platform: IIS 5.0, Oracle 9.2, NT 200 Advanced Server.
>
>
>
> <%
'=========================================================================
>
> Set OraSession = CreateObject("OracleInProcServer.XOraSession")
> Set OraDatabase = OraSession.OpenDatabase("", "system/password",
> cint(0))
> Set OraDynaset = OraDatabase.CreateDynaset("select * from
> MyTest1", cint(0))
>
> Response.write ("RecordCount = " & OraDynaset.RecordCount &
> "<BR>")
> Response.write ("OraDynaset.BOF = " & OraDynaset.BOF & "<BR>")
> Response.write ("OraDynaset.EOF = " & OraDynaset.EOF & "<BR>")
>
> OraDynaset.MoveFirst
>
> 'remove OraSession
> Set OraSession = Nothing
> '=========================================================================
> %>
>
> Many Thanks!!!
>
> Frank
Received on Mon Oct 28 2002 - 08:53:31 CST
