Solved

Retrieving info using ASP

Posted on 1998-04-15
3
168 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why do we like using grid based layouts in website design? Let's look at the live examples of websites and compare them to grid based WordPress themes.
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

863 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

24 Experts available now in Live!

Get 1:1 Help Now