Re: Oracle and ASP

if not RS.eof then

    do while not RS.eof

         response.write RS("DLOC_ID") & " " & RS("DLOC_DESC") & "<br><br>"
     RS.movenext
     loop

    response.write "No records found"
end if

tim

"qwest" <> wrote in message news:zkOga.200$HG6.68222_at_news.uswest.net...
> Hello all!
>
> I'm trying to connect to an Oracle db via ASP and am
> having the following problem:
>
> When I go to the page, nothing displays. It acts (on the
> browser side) as if it were an open loop and doesn't
> finish. I've given it about 10 minutes to run and came
> back with no further progress. My code follows:
>
> <%
> ConStr = "Driver={Oracle ODBC Driver};" & _
> "Dbq=RATDB.world;" & _
> "Uid=DETECTIVE;" & _
> "Pwd=DETECTIVE"
>
> Set RS = Server.CreateObject("ADODB.RecordSet")
> SQL = "SELECT * FROM DISH_LOCATION;"
> RS.open SQL, ConStr
>
> do until RS.eof
> response.write RS("DLOC_ID") & " " & RS
> ("DLOC_DESC") & "<br><br>"
> RS.movenext
> loop
>
> RS.close
> set RS = nothing
> %>
>
> Any help is extremely appreciated.
>
> J :-)
>
>
Received on Sat Mar 29 2003 - 02:06:28 CST