I have some simple code see below.
I have response written out the query and it is valid and returns values
when ran directly against my db, which is Oracle. My OS is Win 2003.
My question is I never get to the point of the loop. It always thinks I am
at the RS.EOF. Similar code works in other asp pages on the same server.
How do I debug this or am I missing something obvious??
Thanks
Mike
CODE
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Conn.Open strConnectStrin g
Set RS = Conn.Execute(SQ L)
If RS.Eof then
Response.write "<center><b >"
response.write "There are no values in the system that match your query."
Response.write "<br>Please Try Again!"
response.write "</b><form>"
response.write "<input type='button' value='Retry' onclick=history .back()>"
response.write "</form></center>"
response.end
Else
Do While Not RS.EOF
<stuff>
RS.MoveNext
Loop
End If
Set RS = Nothing
Conn.Close : Set Conn = Nothing