Solved

Pull data from access based on what user fills out in ASP form

Posted on 2001-06-08
3
150 Views
Last Modified: 2013-12-24
I want to be able to have users fill out an asp form and then have after hitting submit, I want it to pull the data from my access table (based on what the user enters in the form). I've been able to create a form that lets users enter data and have it save to a table. I also know how to have it display all records, but I want to have it display based on what a user fills out on a form? Anyone know how to do this?  
0
Comment
Question by:jcollins1
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
weesiong earned 50 total points
ID: 6170709
jcollins1,

>but I want to have it display based on what a user fills out on a form

Maybe this is what you want:

<%
'Your connection string

Set rs = Server.CreateObject("ADODB.Recordset")
userid = Request("userid")

SQLStr = "Select * from yourtable where userid ='"&userid&"'"
Rs.Open SQLStr, conn, 1, 3
.
.
.
%>

Regards,
Wee Siong
0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6177175
Wee is on the right track...what you need to do is create a select statement based on the criteria you want to pull from the db.

Post a follow-up with specific examples from your page if you need more assistance.
0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6204099
jcollins...are you still there?

Do you require more information or can you close this question?
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Open Page or Post…

809 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