part of this code works but it seems to ignore the password check, any ideas?
If Request.Form("PuafoPassword") = Request.Form("RePassword") Then
strError = strError & "Passwords don't match.<br>" & vbNewLine
Else
If rspuafo.EOF and rspuafo.BOF Then
Response.Redirect ("thankyou.asp")
Response.End
Else
strError = "Username already exists, please choose another one" & vbNewLine
I want to know how to make a match for a text , for I'm wan't to search for this in the db . the search i made search only for the exact text user inserted so if the user misspelled the word the search will give him zero result. So i want to seach for any part of the word or if it is aword in aphrase.
View Replies View Relatedhi there i need to display results that do not match those in the database. I have an excel file and i upload it, inserting the records in a temp table. Than i compare the values in the original table and the temp table. All i want is the values that do not match..i did this:Code:
sql = "SELECT TempSerial.SerialNo "&_
"FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_
"OrderBY TempSerial.SerialNo;"
Set RS = objConn.Execute(sql)
i displayed the records with <%=RS("SerialNo")%> but i get all the records in the temp table displyed.
If i am querying from a database with code like: Code:
Set oRs=server.CreateObject("adodb.recordset")
strSQL = "SELECT * FROM tblInfo WHERE Name = '" & request("name") & "' OR State = '" & request("state") & "' OR Zip = '" & request("zip") & "' "
oRs.Open strSQL, conn
Do while not oRs.EOF
Response.Write "<tr><td>" & oRs ("Name") & "</td><td> " & oRs ("State") & "</td><td>" & oRs ("Zip") & "</td>
oRs.MoveNext
loop
how can i diplay the results that match all three catories before partial matches?
I have a web page programmed in ASP that creates a calling list based
on the user's preferences, which queries the information from a SQL
2000 database. I want the user to be able to select whether to create
different lists based on time zones or one list with all time zones.
The user should be able to mix and match time zones. However, I'm not
sure how to do this task. An example would be that the user wants
east coast and central in one file, then pacific and mountain in
another, but it could also be pacific in one and east and mountain in
another, and the possibilities go on. The database is set up with all
the information needed, but I'm not user how to code in ASP for the
different possibilities.
i want to provide exact match. e.g. if user enters pharma machine result only display records containing pharma machine and not records containing either pharma or machine.
database table: company_info
database field: products
user entered search (field name): st
i had tried the following
select * from company_info where products like '"&st&"'
but is shows the wide result
I have a query that accepts input from a form and deletes a row if the form input = the value in the table .if the input is not in the table how do i post to the user that this data was not found in the table?
View Replies View RelatedI have a form on a .asp page that when submitted via post to itself its values are grabbed by asp and put into an sql statement. From there the records are generated depending on the criteria selected in the form. What I would like some help or guidance is if no records match the criteria how can I generate a meesage that states which criteria in the request did not match.
So if the form submitted is looking for a home in Michigan, Ranch Style, with 2 car garage, 3 bedrooms, 2 baths, between 1000 to 1500 square feet and there is no record that matches that criteria a response is given that the reason for no match is because the 2 bath criteria didn't match or because the 2 bath and the square footage criteria didn't match.
I have the form working with asp already. When there is no record I have a simple statement that says "sorry, no homes matched your criteria" I would like to state why there was no match.
can any one help me to read the datas from the excel sheet and match it with the database.i will be thankful to you if u provide me a sample code.
View Replies View RelatedI want the site to look the same on all browsers. All the tables and stuff are based on percentages but this doesn't fix the images. The images are based to fit 1024x768 but i want them to look the same on every other resolution. Can someone help me with a script?
View Replies View RelatedIs it possible to password protect a web page that has editable text areas defined so that only authorised users can make edits?
View Replies View RelatedI've create a log in page connecting to a database that stores its passwords in MD5. Can someone point me in the right direction on how I can get my login page to recognize those passwords? Here's the code I'm using: Code:
View Replies View Relatedi have the following code to check if two password fields submitted equal each other. If they do then passwordok = 1 else it = 0. No matter that i put in the two fields it always = 0. can anyone see whats wrong? Code:
View Replies View RelatedCan anyone tell me how to apply a password to an Access database and then open the database with ASP. I know how to do this without the password, but have not been able to make the password work.
View Replies View RelatedIn my access database i have 2 tables called seceret question and secret answer. I would like to provide users with thier passwords without using emails. There would be a screen where they can enter thier username, secret answer then thier password will be displayed on the screen. Or alternatively they could just enter thier username and thier password
View Replies View RelatedCan someone help me with creating a password in asp? i know how to create a password for a single user, so how would you create one for multiple users? also i want to know how it is stored in a database, e.g. MS Access
View Replies View RelatedI made a website for my work and we have it secure to where you have to login when you come to the site. But for some reason when you use the check box to SAVE PASSWORD it will not save the password.
So each time a client comes back to the site they have to put thier password in (and they arent happy about it) Just wondering if there is a setting I can turn off or turn on to enable the passwords to be saved.
I have an access dbase that holds and an expiry date. I need to compare the expiry date with the current date and if it is later than the current date it will allow access (if the username password is correct of course)otherwise it will display an error message saying that membership has expired.
View Replies View Relatedwhat is the best way to create secure passwords in a database. I have a login system that can create users but it saves the users passwords in clear text. how would i go about doing this so if people look in the database they will not know the password.
View Replies View RelatedI'm working in ASP (not ASP.NET), and want to create a user database, with username and password. Though it isn't really necessary, since the program will be used on an intranet and by few people, I'd like to have the passwords stored and compared as hash values, for extra security.
However, I'm having trouble finding out how to do hashes in ASP. All the exampes I'm finding are for ASP.NET (and, no, I can't upgrade.) What function(s) would I use for hashing in ASP? Can it even be done?
What I want is to have a user log on with a username/password which I give to them. When they type it in I want it to direct them towards a specific form for them.
What I am doing is running a soccer league. so I want a team to be able to log in and then show up a form where they can enter stats from their game, and about their players which will go into a database. I am unsure how to go about having a different form show up for different users.
I am new to ASP and have been asked to create a login page which will bypass the password (see code below): Code:
View Replies View Relateddoes anyone know of any good tutorials on how to get a login and password checker.
basically ive got a home page with forms to log in and give password which get sent to an asp page i then need to check that username and password with the relevent one in the database or check if they are wrong or do not exist.
I have a requirement to enforce strong passwords from a customer, and I can only assume they won't be the last to ask for it.
Does anyone have any pointers for handling complex passwords? In this particular case I need to enforce.
between 6 and 16 Case Sensitive AlphaNumerics with at least one non-AlphaNumeric character. min and max I've got, but I'm not sure where to go with the rest.
I'm trying to create a MySQL table for users in a Drupal install (as I've accidentally deleted it).
So, i go through my existing tblContacts and write out Firstname, Lastname, email, password, etc., formatted for MySQL.
Everything goes perfect UNTIL i try to MD5 hash the password (via the included MD5_js.asp): for some reason, it is returning the same hash for every user. If the hash function is not applied, each users unique password appears as normal. Code:
We have a web application where we want a user to be able to change his/her password if the password has expired but we are unable to do this with ASP at the moment because we can't log the user into the database without a valid password.
We do not want to store any "admin" user info to connect to the database to change the users password for security issues.Does anyone have any ideas of how we could go about doing this?
I need to tighten up security on my page... only thing is, I can't change file permissions. I have databases and normal files (.dat) that I don't want someone to be able to just type the URL to and be able to get into it all. For example, I have a database with usernames and passwords, but if someone found out/guessed the URL of the DB then they could open it all.
how can I use Encrypt in Access so that if someone guessed the URL then they couldn't just open it? Basically, I know how to do that in Access... but what I don't know is what code to add to my ASP pages to decrypt/un-password protect it so I can open it. If it is possible to stop someone from having access to a file by just using global.asa.
I am using the ADSI objects to retrieve groups and users informations. If possible, how can I retrieve the user password? I've search in Microsoft.com but I find only the SetPassword function (that of course changes the user password).
View Replies View RelatedI have a ASP/vbscript program that generates random passwords. The problem is I need to insert those passwords into an Access database of 327 clients. I have the random password program generating the 327 passwords, but have had no luck inserting them. Code:
View Replies View RelatedI'm working on a "hybrid" application some classic ASP, and some
asp.net. I'm trying to develop a support type page that checks necessary
components, database connections etc.. last item is to check for the .NET
extensions. Is there a way to do that from a classic ASP page?
I am working on a website that requires a login before accessing an appointment book application written in ASP.Basically what I want to do is when the customer first clicks on "appointment_book" link, it takes them to the registration form. After they are registered, It will then redirect them to the actual application.
I also want the same thing to happen when a customer clicks on the login link. I want them to login, then get redirected to the appointment_book.
at the moment the customer click on the registratration link and it shows them the registration form, they are then automatically logged in after registration. However, when I click on the Appointment_book link again, it brings me back to registration form. How can I have the link always point to the appointment book after they are registered or logged in?
let say:
http://www.domain1.com/index.asp?url=http://www.xxx.com/file.asp
can i restrict that only domain1.com can access to http://www.xxx.com/file.asp page?
so when user suft http://www.xxx.com/file.asp, they unable to view the content.both domain is on diff IP.
I have a form with several check boxes.they are all set to default to "unchecked."The db also defaults to unchecked.But,as soon as we hit the "form1.recordset.addnew" all of the cb's change themselves to "checked."?