[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Retrieving info using ASP

Posted on 1998-04-15
3
Medium Priority
?
201 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
percyn earned 40 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
This video teaches users how to migrate an existing Wordpress website to a new domain.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
Suggested Courses

650 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