Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2001-06-08
3
Medium Priority
?
164 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 150 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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

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

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
Geo-targeting is the practice of distributing content based on a person’s location, as best as you can determine it. Let’s look at some ways you could successfully use this tactic. The following tips and case studies could lead to meaningful results.
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…
Suggested Courses

572 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