Microsoft VBScript runtime (0x800A01A8)

[mrdavid57]

I'm getting the following error on the the following code when the query returns an empty record set. It's not recognizing my "if statement". Please Help.

Microsoft VBScript runtime (0x800A01A8)


if rsV.eof <> &quot;False&quot; then
Response.Write(&quot;<script language=javascript> window.alert('The Supplier Number &quot; & rArea & &quot; and Date Range could not be located.')</script>&quot
myConn.Close
set myConn=nothing
set FSO=nothing
Response.Write(&quot;<script language=javascript> history.back()</script>&quot
end if

myConn.Close
set myConn=nothing
set FSO=nothing

 

[spazman]

try
Do While not rsV.EOF
Loop

 

[Mighty]

You are comparing the EOF condition to a string. Try the following:

if not rsV.eof then Mighty