Login Feature Using MS Access
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
ADVERTISEMENT
User Login Feature
the database works is it checks over a database and verifies the username & pass with code. Then the user enters the site and there's a seperate table to keep a record of when users log in and log out.
Well basically I'd like to know if and how I could apply a filter using asp code? I'd like to filter out everything but <%Session("name")%> (which displays their username) so that user logged in can view their own records.
Site Login Feature
I am creating a message board in ASP, and I want to create a login feature where you can view the site without being logged in as a registered user, or you can be logged in and use more features.
What is the best way to go about doing this? Should I use cookies, or should I just try to create a login feature using VBScript and Database values?
Log In Feature Using Two Access Tables
I have a login feature but i want to be able to let users from different tables to log in. The data base is Access and the code is from DreamWeaver MX.
The computer recognises that there are two tables. However i get the message:
Microsoft JET Database Engine error '80004005'
The specified field 'userID' could refer to more than one table listed in the FROM clause of your SQL statement.
/members/loginform.asp, line 21
This is the code:
Limit Login Access
I 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 Need A Login Script With Access Database
I 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.
Page 2 - Login Stamp In Access Database
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"
Create Login Page To Edit Access Database?
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!
Day() Feature
I'm having a hard time with the Day() function. Basically, it appears
to be picking and choosing which part of a date string it uses to
return the result ... heres some code :
New Forum Feature?
I've noticed changes to the forum, for instance... the addition of a "time spent on forums" and user-post "bar" thingiemabob
...And on the front-page I'm presented with a link to "View my warnings"
Which is obsolete, considering that I don't have any warnings (oh, I'm such a little angel!)
Any news or admin care to comment on this?
Attachment Feature
Where do you think I can get just this feature alone in ASP?I just need this feature and not this whole forum. Any other similar product I can use or try?
View Replies View RelatedAdding Feature
I am very new to ASP and I am trying to add an existing script.I have an open source shopping cart and I want to add real time shipping rates from USPS.
I have a username and password for the USPS server,but I am having trouble figuring out where to place it. Also if someone as a script to send and recieve data from the USPS server that would be great.
Search Feature
I need to provide the search feature on the companys web site. I have read one of the threads here that this can be accomplished via Google. I can't locate the thread anymore. Is it possible? could you please point me to the right resources?
View Replies View RelatedFramed Page Feature
i want to have this feature implemented on a framed page: a two paged frame with:
frame (a) containing a textbox and submit button
frame (b) dispays the url entered in the textbox
i have no idea how i'll program the textbox to accepts urls and open the link in the target frame.
Calendar Control Feature
I would like to insert a calendar into a webpage that shows the current date and really needs no updating, fro mthis calendar i would like to select a date from it and have that date inserted into a text field, in all there will be 22 text fields (but for now its probably best to concentrate on one).
The reason being i would like to give the user of the website access to change dates in a table in access. The dates can be calculated from the first date entered into the first text field like so:
All dates will be 7 days apart. Ie if the firsat date is 1/7/04 then make the second 8/7/04 and the third 15/7/04 etc 22 times.
Sorting Asc/desc Feature
I'm building my ASP pages using dreamweaver 8 and some code that I learned along the way.
Can anyone tell me how can I sort (or order) the records in a table just by clicking on any of the columns?
Simple Search Feature
i have a text field that the user can input a keyword to search on. i want it to search two fields in my database: productName and productDetails. can someone tell me the sql i would have to use? I know it would be a mixture of using the WHERE and LIKE commands.
View Replies View RelatedAuto-remove Feature
I have an email program, that I wrote for my newsletter. When I send my emails, I am getting more and more bad emails. Is there a way to have an auto remore feature that will remore the email from my database?
View Replies View RelatedUpload File Feature
how to provide the feature for ploading files from a website? i want sum people to b able to upload their files to my server from website, and I am going to read these files later on for ifferent application. am using ASP and vbscript for my applications.
View Replies View RelatedAdding ASP File-Upload Feature
I was wondering if any one had any advice for adding on an all ASP file-upload feature to a form. To start I only want to upload JPGs to a folder (max 2 per form) and then write the path to these images along with the form information so the images can be displayed later on.
View Replies View RelatedRadio Buttons To Add/change/delete Feature
I have a simple add/change/delete feature going on. I have a products table that I'm selling mock products from. I have a column named category, which users either select baseball or basketball from the radio buttons on a form. I can't figure out how to make this work. I'm implying that the code is working, the record is adding to the database, just not the category field, and when I display all the fields out of my database onto a html page the category field is blank. Below is the code I have.
<tr>
<td>Category:</td>
<td>Baseball<input type="radio" name="category" value="baseball">
Basketball<input type="radio" name="category" value="basketball"></td>
</tr>
Then I dim out a strCategory variable and set it equal to the request object "category"
How Can I Give A Nice Print Friendly Feature Through IE For My Website Visitors
I just wanted to know if anyone can tell me how can I give my website visitors the feature of "FRIENDLY PRINTING" through IE. Code:
View Replies View RelatedXMLHTTP Through Login But After Requesting Next Page - Kicks Back To Login
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?
Login To Page Requires Login
I 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 RelatedASP Attempting To Access MS Access 2000 On File Share
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
ASP + Access Question (Determining The Last Id Generated By Access)
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
View Replies View RelatedAccess A MS Access Database Using ASP But On A Linux Box
I want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
MS Access - Table Access Problem
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table".
If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's.
How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.
Access Remote Access Database From ASP
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
How Many People Can Access The Same Access Database
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
Query Works In Access But Not In Asp->access
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join
SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId
FROM (tblArtists
INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId)
LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId
ORDER BY surName ASC, firstName ASC
Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
Access An Access Link Table
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table.
This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
ASP Login
I have created a login and members page, and checked that it works, so that when you enter the correct username and password it logs you in.
But how can I have it redirect the user to their own personal page? Because I don't want to have different users going to the same page, I want them each to have their own personal members page.