Re: Recordset updating problem

PO wrote:
> Hi!
>
> I use the following script to retrieve records from a Oracle db:
>
> <%
> Dim cn, rs, strSQL

..inetserver.asp.db would have been a better group to ask this question.
However, see below:

>
> strSQL = "SELECT W.WNO, W.ADM FROM APP.WORKTYPE W WHERE W.ADM = 'Y'"
>
> Set cn = Server.CreateObject("ADODB.Connection")
> cn.open "DSN=PROD;UID=" & Session("strUID") & ";PWD=" &
> Session("strPWD")
>
> Set rs = Server.CreateObject("ADODB.Recordset")
> Set rs = cn.Execute(strSQL)
> %>
>
> The code above works fine. However database changes are not reflected
> immediately in my webreport (even after the webpage is re-run). It
> takes about 1 minute before the changes are reflected in the report.
> When running the same query from an SQL-editor (SQL Work***) the
> updates are however shown immediately.
>
> Why does the query run from the webpage not reflect the db-changes
> immediately?

If this was Jet, then I would say you were running into the delayed-write
behavior. Since it's Oracle, I see only one answer:
Caching. See:
http://www.aspfaq.com/show.asp?id=2022

HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.