[SOLVED] ASP-MySQL Username Validation

[Monie]

Hello,
I am having a problem here in MySQL Database.
When I use this code in MS Access, It works fine, but when i switch into MySQL I am having problem with this code:

Code: Select all

'If there is no record with the entered username, close connection and go back to login with QueryString
    If rs.recordcount = 0 then
        rs.Close
        conn.Close
        set rs=nothing
        set conn=nothing
        Response.Redirect("login.asp?login=namefailed")
    end if

I have been searching the net but could not understand anything, lol.
Could anyone of you tell me whats wrong with this code, Thanks.

[Monie]

Ok, maybe no one understand my question, let me clear that!

I have this database connection from MS SQL Access I convert it into MySQL:


MS SQL:

Code: Select all

    set conn = server.CreateObject ("ADODB.Connection")        
    conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("mydatabase.mdb")
    set rs = server.CreateObject ("ADODB.Recordset")        
    'Open record with entered username
    rs.Open "SELECT * FROM userlist where username='"& Username &"'", conn, 1

MySQL:

Code: Select all

    Dim connectionString, conn, rs
    connectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=mydatabase; OPTION=4; UID=root; PASSWORD=monie;"
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.Open(connectionString)
    Set rs = conn.Execute("SELECT * FROM userlist WHERE username='"& Username &"'")

No problem so far, until I reach here:

Code: Select all

'If there is no record with the entered username, close connection
'and go back to login with QueryString with the message username dont exist!
    If rs.recordcount = 0 then '<-- In MySQL, it's like they skips this line!
        rs.close
        conn.close
        set rs=nothing
        set conn=nothing
        Response.Redirect("login.asp?login=namefailed")
    end if

In MS SQL Access, it read the "If rs.recordcount = 0 then" and return an error message to the user "USERNAME DONT EXIST!"
but after using MySQL, the line seems invinsible and it seems that MySQL dont understand it.

Is it something to do with LockType?

[Monie]

Well, nevermind....
I guess everybody in here don't bother much about ASP compare to PHP then..

Lucky I found the solution to this small problem:

Code: Select all

    'If there is no record with the entered username, close connection and go back to login with QueryString    
    If rs.BOF AND rs.EOF Then
        rs.Close
        conn.Close
        set rs=nothing
        set conn=nothing
        Response.Redirect("login.asp?login=usernamefailed")
    End If