Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Verification Code on Registration		  New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 02 December 2013 :  01:56:45  Show Profile  Reply with Quote
There is no mismatch. Something is corrupt. Try typing the line in manually.
Go to Top of Page

Webbo
Average Member

United Kingdom
982 Posts
Posted - 02 December 2013 :  02:31:54  Show Profile  Visit Webbo's Homepage  Reply with Quote
Tried that and even tried re-typing the lines out with a few line breaks...


If Request.Form("Key")>"" Then
   strSql = "SELECT M_NAME, M_PASSWORD, M_NEWKEY" & _
   " FROM " & strMemberTablePrefix & "MEMBERS_PENDING" & _
   " WHERE lCase(M_NAME)='" & trim(lCase(Request.Form("UserName"))) AND "' & M_PASSWORD='" & SHA256(Request.Form("Password")) & "' AND M_NEWKEY='" & trim(Request.Form("Key")) & "'"
      Set rsValid = my_Conn.Execute(strSql)
   If not rsValid.EOF Then
      rsValid.Close
      Set rsValid = Nothing


Still the same mismatch error:

Microsoft VBScript runtime error '800a000d'

Type mismatch: '[string: "SELECT M_NAME, M_PAS"]'

/forum/validate.asp, line 41


I'm offline now for the next 12 hours


Edited by - Webbo on 02 December 2013 02:35:22
Go to Top of Page

cripto9t
Average Member

USA
881 Posts
Posted - 02 December 2013 :  11:56:14  Show Profile  Reply with Quote 


WHERE lCase(M_NAME)='" & trim(lCase(Request.Form("UserName"))) AND "' & M_PASSWORD


should be

WHERE lCase(M_NAME)='" & trim(lCase(Request.Form("UserName"))) & "' AND M_PASSWORD
    _-/Cripto9t\-_
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 02 December 2013 :  12:21:33  Show Profile  Reply with Quote
Yes, thanks. Blinded by looking at it too many times, I guess. That's what happens when you write code and cannot test it.

Edit...

That's odd. I have it correctly on my copy. Must have edited it incorrectly here. Fixed on above posts.
Edited by - Carefree on 02 December 2013 12:26:11
Go to Top of Page

Webbo
Average Member

United Kingdom
982 Posts
Posted - 02 December 2013 :  13:51:33  Show Profile  Visit Webbo's Homepage  Reply with Quote
Doh, can I have the red after you Carefree

I must have looked at that line of code so many times also, it even shows the correct format further on in the same line

I'm pleased to report validate.asp now works
Go to Top of Page

Webbo
Average Member

United Kingdom
982 Posts
Posted - 02 December 2013 :  14:16:44  Show Profile  Visit Webbo's Homepage  Reply with Quote
Carefree, the following piece of code doesn't work:

'" & strEncodedPassword & "' AND M_NEWKEY=

It does not recognise the password being submitted,

The following however does work:

'" & SHA256(Request.Form("Password")) & "' AND M_NEWKEY=


If Request.Form("Key")>"" Then
   strSql = "SELECT M_NAME, M_PASSWORD, M_NEWKEY" & _
   " FROM " & strMemberTablePrefix & "MEMBERS_PENDING" & _
   " WHERE lCase(M_NAME)='" & trim(lCase(Request.Form("UserName"))) & "' AND M_PASSWORD='" & SHA256(Request.Form("Password")) & "' AND M_NEWKEY='" & trim(Request.Form("Key")) & "'"
      Set rsValid = my_Conn.Execute(strSql)
Edited by - Webbo on 02 December 2013 14:17:09
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07