Unless you declared those session variables earlier, they have no data in them. Assuming this information is coming from a form, try using request.form("fieldname") instead of the session variables.
If this doesn't address your problem, give more detail about what "isn't working"
I have index.asp (Form) & process.asp (submit data from index.asp to Access Database), the Form is running Perfectly.
But, How can I create a login name and page for the applicants to edit the information they submitted?
Let say I have Email (username), Password (password) & lastname on index.asp, then I really have no clue!
I am having lots of trouble creating a login stamp in the database to keep a record of when users sign in. The database is Access.
View Replies View RelatedI am trying to build a secure web login that allows me to identify the person logging in by a "Welcome user" message that comes up when they reach the destination page.
Also, I want the person to be able to update their personal info and such when they are in the site. I know how to update a record, but I am unsure as how to tell the database which record to update based on the person who is logged in.
I have been working on a form that updates an access database via a SQL statement. I believe I have the SQL part correct as when I do the response.write SQL I get what I believe to be correct. Code:
View Replies View RelatedHow to insert time stamp data into Access Database when insert other data together in ASP/.
View Replies View RelatedI developed an ASP page which has 2 input fields- First Name and Last Name.I used Access 2002 as database. Once I click the Submit button,
it has to perform 3 tasks-----
1) It has to update the First Name and Last Name in the MS-Access database in their corresponding fields.
2) It has to go to the Home Page(which I already did)
3) It has to update the date/time in the "Time" field in the MS-Access database.
The following is the code I wrote to connect to the database and update the fields in the Access table---
<%
set MyConn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.RecordSet")
MyConn.Open "driver={Microsoft Access Driver
(*.mdb)};;DBQ=c:/documents and
settings/adcguest/desktop/webpage_html
ewsecurity.mdb;"
rs.Open sqlqry,MyConn,2,2
rs.AddNew
rs("firstname") = first name
rs("lastname") = last name
rs.update
rs.close
myconn.close
%>
Can somebody please help me in figuringout if I am missing something.
I have created a asp project local.and have created a access database local. Iam trying to use the access database from the asp page. But It is not accessing the database file.
once i changed the rights of the access file and checked it.It inserted the records.And after some time, iam not able to access it.some times it accesses and some times it doesnt.
I wrote a script to compact my access databases from my admin section. Everything is working except I get this error:
Provider error '80040e4d'
Authentication failed.
Is their some reason the JRO.JetEngine needs authentication? I don't have direct access to this server and was wondering how to get around this problem or how to fix it. It fails when this link is run:
objJetEngine.CompactDatabase strCon, "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " & DBTempPath
None of the databases have a username or password. Would I have to have the host company setup an account for this action to take place? And why could I do everything except compact the database? Is their a vulnerability issue when accessing this function?
I am building a website to pull data from a remote https site using xmlhttp. The data from the https site is behind a login screen. I can successfully get through the login screen with:
set objXMLHTTP = Server.CreateObject("Msxml2.ServerXMLHTTP")
objXMLHTTP.Open "POST", "https://website.com/validate-login2.asp", false
objXMLHTTP.SetRequestHeader "Content-Type", "application/x-www-form-urlencoded"
objXMLHTTP.Send "Username=uname&password=pwd&company=O"
That works great - but then, when I try to go to the next page (where the data is that I want to pull) - I use the same process and I get kicked back out to the login screen? Could there be some cookies, referer, strings being passed normally that I am not including in my second request - How do i find out for sure?
I have used the software IETrace and it looks like some cookies being passed, but how do I know for sure if (and what exactly) it is using?
Currently, I do the following in my ASP pages when making use of an MS
Access database:
Dim adoCon, rsSet, strSQL
Set AdoCon = server.CreateObject("ADODB.Connection")
Set RsSet = Server.CreateObject("ADODB.RecordSet")
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("MyDB.mdb")
strSQL="SELECT * FROM MyTable;"
rsSet.Open strSQL, adoCon
...do some stuff...
rsSet.Close
adoCon.Close
Set rsSet=Nothing
Set adoCon=Nothing
I have a couple queries stored in the database that I use when in MS Access.
Can I call these queries instead of using a string to specify the SQL
command?
The above seems kind of verbose for making use of a database. Can it be
simplified at all?
It all seems to work well, but takes a large amount of time for the entire page to load, I guess due to the amount of records that get displayed, or maybe its the repeat region. So, Is there anything I can do in my asp code to speed these things up. Code:
View Replies View RelatedI've got a simple template based ASP page which pulls information in one of several different languages from an Access database.
The copy I have in the database is fine. All languages - including the Japanese are displaying correctly when I look at them in Access. However, when I pull the Japanese text from the database, each character renders in the browser as '???????'.
I've tried different HTML encoding, but nothing seems to make a difference.
My client has various Access databases that they want to be able to access (using MS Access, not through ASP pages). I thought I'd be able to create the link from an HTML page but when I do that and click the link, the file is downloaded to the local temp folder. I want the database to open directly from the web server, and then changes must be saved.
View Replies View RelatedI want to login to a page using MSXML2.ServerXMLHTTP.4.0 or an object like this, I must send the form variables needed to login when I try to login to the page. But the problem is, that the page looks like a exe file (not a asp file or php file or what ever). The name of the page I try to login is something like "/pw?/session/login", nothing more, without extension. I have tried the code with a normal asp file with session registration and login process and it worked, but not with this file.
View Replies View RelatedI have page for user to update his/her details. What i want is after idle for more than 20 mins, the page will redirect to login page automatically. So that the user knows that his/her session already expired and need to login again.
But it doesn't working. This is because if he/she update the details (after idle more than 20 mins), and click the Submit button, it will go to login page and all the data will be lost. Code:
I have a website which requires login. The login function works fine, but I want to display this message when someone is logged in: "Welcome, Firstname Lastname". Here is the code for login.asp: Code:
View Replies View RelatedI want to limit user login by writing ASP program. In details, if a
user had logged in wrongly for more than three times, then the user
will not be abled to log in to the system anymore even thought he key
in correctly the username and password in the 4th time. That's means
he cant login forever until the administrator edit his status in the
database Can i refer to any ASP sample coding for this application?
I am looking for a simple code of login to db
of asp dotnet (vb dotnet code).
with user name + password & simple database.
When login to database - I want to see a table data with all it's columns.
I am trying to connect to a database and verify a users login and password,
then based on that login information display 3 pages based on their login.
On the home page if they are NOT logged in, I need it to display the login
box, if they ARE logged in I want it to display Welcome Customer Name from a
database called vcust.dbf which contains both the username and password
fields.
The two other pages will be based on the username (which is actually my
customers customer number ... example '100001'). I am needing to display
the customers account informaiton on one page from the vcust.dbf and their
rental history on another page from records.dbf. Code:
I am introducing a password login script to my site.I know how to password the site but am looking for good ways to password protect to users can only access their details and no-one elses.Also i was wondering whether to use SSL or not.
View Replies View RelatedI had just created a login page called login.asp and proc page login_proc.asp. I'm using MS Access for db. The prob is when I uploaded it into the web, a msg comes up saying 500 Internal Error and could not find login_proc. I have uploaded it dozens of times but it still comes out the same. When I test it in my local server, everything goes smoothly. Can nebody plz help? I'm running out of idea. I feel like jumping off the bridge rite now.
View Replies View RelatedI have existing login page that will check accounts table from my database
if the user is allowed to log on to the system. I use session to save user
variable.
Every page that I will make, I always ask if the session where I
save the user variable exist, and if not, it will redirect to login page. Is
the the best way to control a web application using ASP. If not, can you
give me your thoughts?
I got a web page and I want the user to login everytime he view the page. Something like email where u need to login be4 u can view the inbox. What can I do so that if the user want to go straight into the page I will direct him to the login in page to ask him to login first? Another question is what does this mean?
<!--#include file="setting.asp" -->
First my database consists of a couple tables.MyUsers (records - username, password, tablename)User1 (records - record 1, record2, record3)User2 (records - record 1, record2, record3)
What I have a username and password login. When they login I need asp to look up in a database (table - myusers) and if the username and password match one of the records then take the third record (which is actually a reference to that user own table) and store it in a variable.
I then need to read that users table and display all the info in that table on a new page for only that user to view.
Below are the files that I have. I have been messing around with it with another example so some of the code might be a little misleading....
I am trying to store the current date to an ms access database on my server.
I set it up with a dsnless connection.
Here is the statement:
Insert Into employees(timestamp) Values ('" & date() & "')"
the timestamp field is of type date/time in the ms access database.
I get an error saying the insert statement is invalid. Cannot get you the
exact error, my server is down.
But it seems that the syntax is correct.
I have a guestbook and want to add a date field. I want the date field to be automatically stamped as it were when someone submits a new entry to the guestbook, how can I do that? My database is Access by the way.
View Replies View RelatedI have an asp form which is capable of entering a Now() datetime stamp. Can anyone show me how I can then use this information to let change some text once 48 hours has passed? I.E. compare the now() time stamp with time now. As yet I've tried to use Date() but this does not count to exactly 48 hours after the initial time stamp.
View Replies View RelatedPlease need your help in writing the cookies code to enter the user automaticly to the comments page with out login if he entered before to the site...
these are the code i wrote but now i need the cookies code to vlaideat if the user enterd before or not (if yes, redirect him to the comments page otherwoise let him login in)
I want to be able to send users links to pages in my website. But if
they arent logged in I want them to first be redirected to the login
page and after they login automatically be redirected to the page i
sent them in the link. How would i accomplish this.
We have a requirement where we have to develop a custom Login Page which
will accept user's NT credentials ( Username , password, domain name).
This then needs to be passed to a website which uses Windows Authentication
my question is how do we pass these credentials to IIS in classic ASP?
I created a Login User page with VBScript in Dreamweaver MX but whenever I preview the page I get the following error:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/website/TMP2n38d8z06e.asp, line 24
MM_redirectLoginSuccess="customer_section.asp?id=<%=(rsCustomerLogin.Fields.It em("username").Value)
(It's pointing to the beginning of "username.")
Line 24 of my code is:
MM_redirectLoginSuccess="customer_section.asp?id=<%=(rsCustomerLogin.Fields.It em("username").Value)%>
What I'm doing here is trying to pass the corresponding record to the next page for the user that just logged in. If I don't pass the link parameters, I can preview the page and log in with no problems. So the problem only occurs when I try to set those link params.
I noticed that the first quotation mark isn't closed, so I started placing quotation marks in that line trying to close it, but still get the error. I also noticed that under this line of code there was a quotation mark on a line by itself which I removed to see if that would help, but didn't. Code:
I have a login page where i validate my user id and password... this part is done... I need to get the user id to the next page i am showing...
Example like:
-------------------------------
Login Page
userid : abc
pwd : XXXXX
Authentication Successful
---------------------------------
Next Page:
Welcome abc ---> i want it here
----------------------------------
Anyone can show me how shld i do it...