Solved

Retrieving info using ASP

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

"In order to have an organized way for empathy mapping, we rely on a psychological model and trying to model it in a simple way, so we will split the board to three section for each persona and a scenario and try to see what those personas would Do,…
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

730 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