Solved

Retrieving info using ASP

Posted on 1998-04-15
3
162 Views
Last Modified: 2013-12-25
I have a database for student information.  What is the best way for students to retrieve only there information out of the database without getting someone elses.  
I have it set up now - they enter their name and id on every form they submit and I use that as a means for them to retrieve that information out of the database without getting someone elses data.

Is there another way to go about doing this?
0
Comment
Question by:jwilliams1
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
percyn earned 20 total points
ID: 1858280
If this is an ODBC complient databse, this is very simple to do with ASPs, using ADO.

Simply execute a SQL statement like this :

sql = "SELECT * from StudentTable WHERE Name in ('Name')"
0
 

Expert Comment

by:clsmaster
ID: 1858281
You can also save the name in the Session Object so that the student does not have to keep reentering it.
ex.
Session("Name") = StudentName
0
 
LVL 3

Expert Comment

by:percyn
ID: 1858282
But only use the Session object if you are hitting one server and not load balancing between multiple servers. A cookie however would work in both cases.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
Any business that wants to seriously grow needs to keep the needs and desires of an international audience of their websites in mind. Making a website friendly to international users isn’t prohibitively expensive and can provide an incredible return…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now