Hi there :)
I have build a login page using ultradev ....I have loaded the page online but when I try to login in I get an error message saying
80040e07 data type mismatch
I have gone over the code several times(also rechecked my database fields the fields are number fields) I have gone over the code several times and I cannot find what is wrong with it.Could someone pls help me out .....tell me what I am doing wrong. The all the code is pasted below:
This is causing me a lot of distress......
<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/orange.asp" -->
<%
// *** Validate request to log in to this site.
var MM_LoginAction = Request.ServerVariables("URL");
if (Request.QueryString!="") MM_LoginAction += "?" + Request.QueryString;
var MM_valUsername=String(Request.Form("AccountNumber"));
if (MM_valUsername != "undefined") {
var MM_fldUserAuthorization="";
var MM_redirectLoginSuccess="mfxUNLOCK.asp";
var MM_redirectLoginFailed="atlogin.asp";
var MM_flag="ADODB.Recordset";
var MM_rsUser = Server.CreateObject(MM_flag);
MM_rsUser.ActiveConnection = MM_orange_STRING;
MM_rsUser.Source = "SELECT AccountNumber, PinNumber";
if (MM_fldUserAuthorization != "") MM_rsUser.Source += "," + MM_fldUserAuthorization;
MM_rsUser.Source += " FROM Login WHERE AccountNumber='" + MM_valUsername + "' AND PinNumber='" + String(Request.Form("PinNumber")) + "'";
MM_rsUser.CursorType = 0;
MM_rsUser.CursorLocation = 2;
MM_rsUser.LockType = 3;
MM_rsUser.Open();
if (!MM_rsUser.EOF || !MM_rsUser.BOF) {
// username and password match - this is a valid user
Session("MM_Username") = MM_valUsername;
if (MM_fldUserAuthorization != "") {
Session("MM_UserAuthorization") = String(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value);
} else {
Session("MM_UserAuthorization") = "";
}
if (String(Request.QueryString("accessdenied")) != "undefined" && false) {
MM_redirectLoginSuccess = Request.QueryString("accessdenied");
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginSuccess);
}
MM_rsUser.Close();
Response.Redirect(MM_redirectLoginFailed);
}
%>
I would be grateful for any help.