?
Solved

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

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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. 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 :…
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…
Suggested Courses

741 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