Solved

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

Posted on 2001-06-08
3
147 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
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 properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

708 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

12 Experts available now in Live!

Get 1:1 Help Now