hey, you could rename your fields in your table to username and password to avoid confusion as to how it goes in the sql statement???

hey, how can i response.redirect to a parent frame?

thanks

This is the thread that won't die =P Anyway you can't use response.redirect to do this, you have to use some Javascript trickery and a Response.Write():

Dim sJavaScript
sJavaScript = "<script language=javascript>"
sJavaScript = sJavaScript & "parent.frames[n].location.href='page.asp';"
sJavaScript = sJavaScript & "</scr" & "ipt>"

response.write(sJavaScript)

In the line: parent.frames[n].location.href='page.asp'; n is equal to an integer value OR the name of the frame. If using the frame name, surround it in ' '

Also, please post all further questions in the Classic ASP Beginners forum, I wrote this entire reply in .NET and totally forgot we were discussing classic ;]

hth



================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

Hi again.

Well, I took a few days off to try and get my login page working. I found some great articles on the topic, and tried out different approaches to fixing my problem. However, I truly am stumped at this part. I receive an error message that is as follows:

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

I understand that the EOF has to do with the login info (i think), but I do not understand why it isn't supported.
Below is my code again. I have tried variations of what is there, but none of them work.
Any thoughts?
<%
dim username, password
username=TRIM(Request.Form("Uname"))
password=TRIM(Request.Form("Pass"))

If username <> "" AND password <> "" then
   Dim objConn, sql, rec, dbPath
   dbPath="/db/HockeyCards.mdb"
   set objConn = Server.CreateObject("ADODB.Connection")
  objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath(dbPath) & ";"
'Select the record matching the username.
   sql = "SELECT * FROM CustomerList WHERE Uname='"& username & "' AND Pass='" & password & "'"
   response.write(sql)
   'If no match found, EOF is not true.
   if NOT response.EOF then
      Response.Redirect("sorry.asp") 'Change to page redirect to after login
   else
      blankError="Invalid username." 'EOF is true, no match found.
   end if
else
%>
Note: I have tried to "highlight" the line in question.

Now is the only thing that's real.

....You don't have a recordset object open. .EOF stands for End Of File and it is how you determine if a Recordset (or datastream) has read to the end of file. The response object does not, in fact, support EOF nor will it contain the data you are looking for in your if statement. The response object has to do with sending data to the browser.

you need to do this:

set rec=Con.execute(sql)
   'If no match found, EOF is not true.
   if NOT rec.EOF then
      Response.Redirect("somepage.asp") 'Change to page redirect to after login
   else
      blankError="Invalid username." 'EOF is true, no match found.
   end if

In this instance you implicity convert the variable rec to a recordset.

I think you will find that that will work for you.

Lastly, as I said to neil please post all further questions in the Classic ASP Beginners forum since this forum is for .NET 1.1.

Thanks.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

hi,

i am new to asp. problem is i am not able to execute my asp files. i have iis in my system. but inside iis->web sites->empty
i should find default web site inside web sites folder. but that folder is empty.and even ftp sites folder also empty. i do not admin rights. so what i can do to execute my asp files.

Thanks