Wrox Programmer Forums
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 8th, 2005, 02:36 AM
Registered User
Join Date: Mar 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default view table using asp code

hi..anyone can help me?..i have a problem regarding view a record..actually my problem is i want to view a record for certain data only..at first user can see all the data in view report..then user can select which data(colum involve in view table) they want to see..then only the selected data will be appear in the screen..but i dont know how to do that?..could u please help me?..by the way i'm using asp for this coding...tq
Old March 8th, 2005, 02:17 PM
Authorized User
Join Date: Aug 2003
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to sherief Send a message via Yahoo to sherief


what database do you use?

Sherief C. Mursyidi
Old March 8th, 2005, 04:51 PM
Registered User
Join Date: Mar 2005
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts


Old March 8th, 2005, 06:51 PM
Friend of Wrox
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41

Hopefully I have understood your problem...

You are currently showing a table of results?
1..When you get your records are you pulling a unique identifyer?
2..Make an element in each row clickable (an icon, text or whatever)
3..In the link pass the unique identifyer as a QueryString value.
Post the link to the same page. My identifyer is called ID and the value is held in a record set called rs Eg:
<a href="pageName.asp?Id=<%= rs(0) %>">Click me</a>
4.When this link is clicked the page will reload (passing this querystring) At the top of your page I would do something like:

   IF request.querystring("id") <> "" then
      'user has clicked the link so run the sql showing the selected record only
      'run the sql here to pull all records (default page view)

NOTE : Use the same recordSet name for both queries. This way you only need one loop on your page. It will show all records, or just the one asked for when the user clicks the link

BTW : It doesnt matter what DB you are using, this theory will work either way. From reading your post the connection and the query to show all records is not part of your problem?

Wind is your friend
Old March 8th, 2005, 07:46 PM
Registered User
Join Date: Mar 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts

i'm using microsoft access as a database

Similar Threads
Thread Thread Starter Forum Replies Last Post
updating the table from the list view columns Yasho VB Databases Basics 2 July 31st, 2007 02:06 AM
evaluate asp.net code stored in DB table jpamental ASP.NET 2.0 Professional 1 February 13th, 2006 01:32 PM
Requires a Tree view code in asp suniltpatel79 Classic ASP Basics 0 June 16th, 2005 11:17 PM
Table View and DB Changes rander3328 SQL Server 2000 3 September 16th, 2004 11:18 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.