I'm working on a site which is password protected using ASP and an Access database.
I need to require that new passwords be at least 8 characters and contain at least one character from upper case, lower case, number and special characters. I've searched but haven't found anything that looks like it would work - only scripts to prohibit certain characters.
function mt_valForm(val)
{
var passed = true;
var mt_error = '';
if (val.txtusername.value == ""){passed=false; mt_error+="Please provide a user name
"}
if (val.txtpassword.value == ""){passed=false; mt_error+="Please provide a password
"}
if (val.txtemail.value.indexOf("@") == -1 || val.txtemail.value.indexOf(".") == -1){passed=false;
mt_error+="Please provide a valid email address
"}
if (mt_error!= ''){alert ("There were errors - please correct these:
I am currently writing a little gadget where users can create, delete, alter... tables in a database. Some kind of MyAspAdmin... Everything works fine as long as I specify the MSSQL-Login-Infos database, user and password.
But if I want to make it possible to switch from one database to another, here comes the problem: The user has to choose a database that he wants to work in, and type in user and password.
I need the (probably very easy) solution, how i can check if this user/password/chosen_database combination is correct. Code:
I'm using SQL/ASP, I'm trying to pull a record from one mdb table and copy it to another mdb table, but i'm having some problems.. here is my code:Code:
Sql_sel = "SELECT Top 1 CUSTID FROM cust ORDER by CUSTID DESC" CUSTID = Sql_sel response.write(CUSTID)
Line 1, CUSTID being the ID field, cust being the table which holds the records. Line 3, is a test to see if it pulls the right data, unfortunately it doesn't infact where i was expecting to see the lastest CUSTID displayed it infact just displays Line 1 as i have written it. This mkaes me beleive that i have made a simple syntax error.. can anyone spot any faults?
I have a recordset that returns say 5 records. I want to loop through the recordset until three specific conditions are meet in one of the records. Code:
I am working on a login form that asks for either a login number OR first name and password. When all three fields are completed on the form, my query only checks to see if the first condition is true. I need code that keeps users from only filling out the first condition (login) or the second condition (first name and password), but not both. Code:
I have a form which accepts the username and password. I am storing it in an Access Database. How do I check if the user already exists in the database by passing SQL queries? Could someone possibly give me the code or maybe a link.
I have a webpage where there are two drop down menues. From each of them, one item can be selected. I need code to test if there was an item selected from both the drop down menus. How do I do this? Do use ASP or HTML?
Is there a way in ASP to verify digital signature by using one of public keys contained within the application's PSE (Personal Security Environment) file?or if this is not possible, can it be verified by using the public key itself, the CRT file?
SELECT * FROM biblewheel_url INNER JOIN bible ON biblewheel_url.letter_id = bible.book_spoke WHERE ( text_data like '%number%' OR text_data like '%day%' OR text_data like '%forty%' OR text_data like '%year%' ) AND bible.book_spoke = '4' Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
I have a client who wants to password protect a learning course that is set up in modules. Each module needs to have it's own password protection so users can only access them as they progress through the course.
Each user should have their own password (for each module) and, said client would like the password to expire for the user at some (predetermined?) point. Is this possible? It seems like a lot (in terms of setup), but I don't know much about password stuff.
If it is possible, can someone give me an overview of how it works (theoretically) or where to find more specific info on setting something like this up (in ASP.net)
If it isn't possible, can someone suggest what is more reasonable in terms of protecting the modules?
I would like some help in having the form check to see if the selected course is available before submitting the info to the database and instructs them to choose another date if the course is closed. I have a qry that does a check and brings the information on availability. Any way to run that qry -check and send back the message or submit the confirmtion?
I created sessions to authenticate username and password. How can I utilize this same script to alert the user to change password at 3rd login? In other words when a user logs into a site after the 3 or 4th time which ever, they are prompted to change their password. Code:
I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus.
Just starting to play with scripts, and need a little guidance. I want to check to make sure that the email addresses users enter in a form are identical before it will allow them to submit. here's what i have:
the variable for the second email address is EmailFrom2
'validation Dim validationOK validationOK=true If (Trim(EmailFrom)="") Then validationOK=false If (validationOK=false) Then Response.Redirect("emailerror.htm?" & EmailFrom) If (Trim(Name)="") Then validationOK=false If (validationOK=false) Then Response.Redirect("nameerror.htm?") If (Trim(CityState)="") Then validationOK=false If (validationOK=false) Then Response.Redirect("citystateerror.htm?") If (Trim(SchoolName)="") Then validationOK=false If (validationOK=false) Then Response.Redirect("schoolnameerror.htm?")
I have created one of those change your password forms whereby the the old password and new password are provided.
What I am having trouble with is ensuring that the old password entered actually exists already. Below is what I have tried, but I am getting a syntax error:
Code:
'Check Password
if request.form("CusPassword")<>rsCheckUser.fields("CustomerPassword") then
response.write "Invalid password"
end if
Else
if request.form("CusPassword")= rsCheckUser.fields("CustomerPassword") then
'write new password to databasestrSQL ="UPDATE Customer Set CustomerPassword ='"& NewPassword& "',CustomerPasswordverified ='"& NewPassword& "' where CustomerEmail = '"&CusEmail&"' "
I want to create a password validation system..... There are two text boxes.... I want to make sure that the passwords are the same and that they are more than 8 characters.
Im planning to encrypt the password that was stored on msaccess database and also the text inputed from a password textbox. Also, if I want to get the password from the database, I need to decrypt it so it can be comparable to the one that is inputed on the textbox. Is there a way on how to handle this?