?
Solved

Retrieving info using ASP

Posted on 1998-04-15
3
Medium Priority
?
195 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
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…
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…
Suggested Courses

771 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