EOF & BOF are not working..

[snowboardr]

No matter what I try I can't get it to not error if a user is not found. I have tried everything accept the right way I guess!

I get this error trying to do it this way:


If Not rs.EOF Then
Response.write username
else
Response.write "Not found"
end if


Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'EOF'
profile.asp, line 65

I have tried this way as well:


If EOF or BOF then
response.write "user not found"
else
response.write username
end if


Any suggestions??

-Jason

 

[mlawson]

Have you tried wrapping "" around username? Is username a field item?
Occasionally I have found that enclosing the response statement within the <% %> helps.

Give it all a go!

M

 

[snowboardr]

Its not the username ...it errors on the EOF line.

 

[mlawson]

The reason I mentioned the above was that I was getting a similar error when trying a fiddly response.redirect.

&quot;Object doesn't support this property or method: 'EOF'&quot;

Sorry to be blunt, but rs is the name of your recordset?

(Don't ask - you'd be surprised!)

get back with a bit more of your code..

M

 

[snowboardr]

yea its rs lol thats the first thing i checked.. good thought though somedays I'd have probably looked over it...but this little &quot;problem&quot; has been with me for a couple of days now..

ConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db.mdb")

set my_conn= Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.RecordSet")

my_conn.Open ConnString

strUsername = CStr(Request.Querystring("username"))

StrSQL = "SELECT * FROM users WHERE username=" & "'" & strUsername & "'"


'StrSQL = "SELECT * FROM users WHERE username=" & "'" & Request.QueryString("username") & "'"  [works]

rs = my_conn.Execute (StrSQL)


If rs.bof and rs.eof then 

Response.write "User not found"
Response.End
else
'Build page..
%>

 

[SrinuReddy]

I think the problem is not with EOF and BOF the problem is with the RS object itself. For some reasons it might not have set. So first check if RS is really is not NOTHING. So before

rs = my_conn.Execute (StrSQL)

statement use:

if rs is nothing then
Response.rtie(&quot;error in getting records.&quot
Else
if not(rs.EOF and rs.BOF) then
response.write(&quot;records Present&quot
Else
response.write(&quot;No records.&quot
End IF
end if