Validate MS SQL Logins
I need to know how to validate a user and password that is in the MS SQL Logins. (Not a table)
View RepliesI need to know how to validate a user and password that is in the MS SQL Logins. (Not a table)
View RepliesI'm trying to make my login page also insert into a seperate table a list of users when they login. The current code returns no errors but does not write to the table. It is still checking the user and password correctly but that's it. Any ideas? I'm sure it's something stupid but I can't see it. Also is there anyway to encrypt the login too? Code:
View Replies View RelatedI have a problem with restricting multiple users to get access to my site with the same username and password.
I allready set up a table getting the UserID of the user and putting it in the table, therefore restricting access for future logins as long as the users Session is still valid.
Now to my problem. When the user logs out everything is great, but when he just closes IE the session is still valid and the field in the DB will not be deleted. I have put a SQL in the Sessoin_OnEnd in the global.asa file, but since this site is a micro site in another folder than the root, the global.asa can effect the main site aswell. And it will take at least 15 minutes before he can login again (and I do not want to set session.timeout any lower).
I want to prevent multiple logins in my web application. For eg:If a user "userA" logs into the application,some other user with same userid "userA" should not be allowed to login as long as previously logged in "userA" is active.
Is there any solution? One method I thought was when user logs into application,
I set a flag in table.If user logs out of application from the logout button explicitly provided in application, I reset the flag for that userid.But if user closes the application from browser(close) , I am unable to find a way to reset a flag.
I would like to prevent a user from logging in with their user/password combination on a different computer or even a different browser window, if they are already logged in. I have a login page, from which I use a DB check to verify user/password info. Also, I have a bit loggedIN field in the DB, which I use to see if they are currently logged in; if so, I prevent them from logging in a second time.
Unless they click the "Log Out" button, then the DB value does not get changed. Any suggestions as to how I can log them out, even if they simply close the browser window or jump to a different page?
I need to display the # of online users on my system, as well as the 10 users that last logged in at that moment....How would I do this? Im sorry if question is vague but I've never done this before and I've no idea how to do it. Will I be needing an application variable? Do I have to use it on a global.asa file?
View Replies View RelatedIm trying to detect multiple logins...
Im using a application object in my global.asa, for some reason it doesnt seem to work. here is my code
<script language="vbscript" runat="server">
Sub Session_OnStart
Session("LoggedIn")=0
End Sub
sub Application_OnStart()
Application("Logged")=1
End sub
</script>
In my pages if i print the Application("Logged") value, it does not show....
I would like to create an auto-lock out module where users are unable to continue login attempt after 3-5 unsuccessful logins. In addition, the user account are automatically suspended after stipulated unsuccessful logins. Is there any sample coding in ASP or Javascript for me to refer to??
View Replies View Relatedi want a user to enter an amount in a text box he can enter it in different ways like this
$12.00
12.00
12
$12
anything other then this should not be valid
like if he enters
"fasfdasdasd"
this is not valid does someone has a script for it Code:
I have a date entry on a form that must be at least 30 days from the current date. It is a delivery request date and the soonest it can be processed is 30 days from the request. I need code to validate and message should they enter a date less than 30 days from the current date.
View Replies View Relatedi have three combo box in my form and if one combo box empty it has to say eror message,
View Replies View RelatedI've been given a task to write an function to validate URL's used on a website. The URL's are going to be kept in a table with other fields to indicate if the URL is valid and when it was last validated.
Any URL's that aren't valid won't be displayed on the site. Is there a way in ASP to check if any given URL returns a 404 error?
How can I validate a date, like 3/26/04, before submitted?
View Replies View RelatedI 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&"' "
Does anyone have a nice javascript message that chacks whether a valid email address has been used in the form?
View Replies View RelatedI have a form which consists of a few fields. The problem that i encountered was it seemed like just checking the first field only rather than all the fields. Code:
View Replies View RelatedI am looking for a way to do a validation in the form that who ever is filling the form is a true person & not a automatic system. there is a way to do it with letters in an image & the user must enter the same letters in a text field.
View Replies View Relatedi am validating a textbox i want data to be entered as Firstname.Lastname
so there should be "dot" between the firstname and lastname
if there is no dot then fire an alert and here is the code but its not firing the alert am i doing something wrong Code:
I've created an xml document with Microsoft's XMLDOM. How can I validate
the xml I've created against a schema (xsd) ?
I am wondering if there is a way to validate a user's login from 2 different tables.
Currently I have a sql string that pull info from a table based on the users login and password.Code:
sqlStr = "Select * From authorised_user_table where username = '" & Request.Form("username") & "' and password = '" & Request.Form("password") & "'"
My problem is I the passwords in this table are old, and I have a new table with all new passwords (same structure, just different passwords). I'm thinking most of the users don't remember their new passwords just the old. So is there a way I can query both tables? Something like Select * from table1..... else Select * from table2
I once saw somewhere, and I cannot recall the site / article... But I believe there is a way that you can "Check" an E-Mail Address to make sure that it is a Valid Email Address. NOT Syntax checking... But to actually determine if the email address typed in is a "Real" and "Active" E-Mail Address.
View Replies View RelatedI realize this is not solely an ASP question, but I thought you guys might
know the answer and I couldn't find anywhere else to post this. If you have
suggestions for this I am more than happy to post somewhere else.
How can I, using ASP code, validate whether or not an email address is a
real one? For example, if I have the email address called Join Bytes!
how can I determine if it is real?
A form is passing "firstName" and "lastName" to your ASP page.show code how to validate them server side validation as follows:Only Alphanumeric characters,commas,hypens, spaces or periods are allowed in the last name.
Only A-Z, the hyphen are allowed in the first name.Both fields must be provided.Return a string value from your validation indicating to the user what is wrong with their entry. "
I am trying to validate the success of Server.CreateObject through
Code:
Dim MyObject
MyObject = ""
Set MyObject = Server.CreateObject("ThisObject.Something")
'// Check if the object was created
If MyObject <> "" Then
However this code fails:
Microsoft VBScript runtime error: Object doesn't support this property or method
Is there a way I can test if the object was created successfully?
I am using this code to validat a checkbox in a very big file, the problem is,its not validating:
here is my code
function checkAgree(theform){
if(theform.Agreement.checked == false){
alert("Please tick the checkbox to continue.");
theform.Agreement.focus();
return false;
}
}
<form method="post" action="check.asp" onSubmit="return checkAgree(this)">
<input type="checkbox" name="Agreement" value="Yes">
<input type = "submit" name="submit" value="Submit ">
I have 2 fields on a form called 'name' and 'title'.
I want to make the 'name' field compulsory to fill in on a form. So if someone submits a form and the name field is not filled in, it will tell them and won't let them submit.
But I only want the name field to become compulsory when the 'title' field is filled in. So if the title filed is blank then the validation will not be effective but if the title field is filled in then the name field will become compulsory. Code:
I just realized that it's so important to validate each string, I mean
'each' before you insert data from asp page into database.
I guess some customers just copy data from some electronic document and
paste intoform field which it will probably mess up the program.
for example, we have a customer who wants to enter AH12345 into one of our
fields, it appears Ð?Ð?12345 in hidden field of our asp page, but it displayed
AH12345 to the customer, but our program failed because of the data does fit
into char field in sql database.
I don't know in reality, how other companies deal with those kind of thing.
Do I have write our own regExp to validate each string, since we do need to
allow apostrophe or "-" in first name or last name.
Should i validate cookies values?
View Replies View Relatedi am getting this error message when i validate my page and it is
Error: formobj has no properties
Source File: /sellgiftnum.asp?
Line: 55
and line 55 is this one
var obj = formobj.elements[fieldRequired[i]];
Can someone tell me whats wrong with it .....
I have functions with which i can validate a URL from serverside. But, i need to valide the URL at the Client side (ASP- Javascript) itself. Is there any way to validate a given URL from the Client side.
View Replies View RelatedI have a form that users fill in, thefirst field is a username, which
must be unique.Currently only when I attempt the Insert into the DB does the restaint
inform the user that it already exists.Is there any way i can check , let say onblur, if that username exists, so that they dont have to complete the whole form before being
informed?
how do I add this to my form? I don't understand.
Function chkEmail(sEmail)
Set objRegExp = New RegExp
searchStr = "^[w-.]{1,}@([da-zA-Z-]{1,}.){1,}[da-zA-Z-]{2,3}$"
objRegExp.Pattern = searchStr
objRegExp.IgnoreCase = true
chkEmail = objRegExp.Test(sEmail)
End Function
How can we validate credit card in ASP?How can we create a dll file in VB?
View Replies View Related