If record is not there.. what to do?

[snowboardr]

I am calling a recored using the users username, how do write out "User not found" if the user doesn't exsist in the db?

- Thanks

 

[gsc1ugs]

If not is database

if not rstChkAgain.EOF then
Response.write "results "&rstChkAgain("username&quot
else
Response.write "Nothing found"
End if Regards gsc1ugs
"Cant see wood for tree's...!"

 

[gsc1ugs]

Is the check

strSQL = "SELECT username, password FROM users WHERE username = '" & Request.Form("yourusername&quot & "' AND passwrod = '" &Request.Form("yourpasswrod&quot&"'"
Set rstChkAgain = objConn.Execute(strSQL)

if not rstChkAgain.EOF then
Response.write "results "&rstChkAgain("username&quot
else
Response.write "Nothing found"
End if
Regards gsc1ugs
"Cant see wood for tree's...!"

 

[gsc1ugs]

Is the check

strSQL = "SELECT username, password FROM users WHERE username = '" & Request.Form("yourusername&quot & "' AND passwrod = '" &Request.Form("yourpasswrod&quot&"'"
Set rstChkAgain = objConn.Execute(strSQL)

if not rstChkAgain.EOF then
Response.write "results "&rstChkAgain("username&quot&" Logged in"
else
Response.write "Nothing found"
End if
Regards gsc1ugs
"Cant see wood for tree's...!"

 

[snowboardr]

I get an error using the first code:

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

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

rs = my_conn.Execute (StrSQL)

'# ------------------------

Microsoft VBScript runtime error '800a01b6' 

Object doesn't support this property or method: 'EOF' 

/profile.asp, line 105 

'# ------------------------

<% if not rs.EOF then
Response.write &quot;Found&quot;  '( just testing )
else
    Response.write &quot;Nothing found&quot;
End if 
%>

 

[gsc1ugs]

This is wrong

StrSQL = "SELECT * FROM users WHERE username=" & "'" & Request.QueryString("username&quot & "'"

Should be

StrSQL = "SELECT * FROM users WHERE username=" & '" & Request.QueryString("username&quot & "'

Is the username in the reply back...ie
name.asp?username=gary....? if not then the above wont work..you need to get the username from your form or out in in the link... Request.form("username&quot ...


just to summarise..

users = table in db
Request.form("username&quot = from tour form
else
Request.QueryString("username&quot from your reply back in link
ie name.asp?username=gary

then really syntax should be

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

then use

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

Hope it helps


Regards gsc1ugs
"Cant see wood for tree's...!"

 

[snowboardr]

- Thanks for all your help..Im new to the forums how do you rate a person so I can rate you..?

This won't work because you are commenting out the querystring line..

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

The strSQL I am using works fine, I can get a user and display there record with profile.asp?username=username, its just if you goto a user that is not there it shows this:

---------------------------------------
ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

profile.asp, line 31
---------------------------------------

I am calling a user exactly how this site is calling a user:
This is a sample of a user that doesnt exsist...

http://www.facethejury.com/profile.asp?user_name=usernotfound

It actully removes the middle tables and everything... and then says "This user does not exist"

 

[gsc1ugs]

Sorry your correct

SQL = "SELECT * FROM users WHERE username=" & "'" & Request.QueryString("username&quot & "'"


If you feel the thread as been useful then you click the

Click here to mark this post as a helpful or expert post!

Tara :-0 Regards gsc1ugs
"Cant see wood for tree's...!"