Wrox Programmer Forums
|
Access ASP Using ASP with Microsoft Access databases. For Access questions not specific to ASP, please use the Access forum. For more ASP forums, please see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access ASP 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 June 28th, 2003, 11:07 PM
Registered User
 
Join Date: Jun 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database advice

I am creating a web based educational testing site. Teachers can add modules to the site for different classes. Most of these modules will be custom programmed. When a student logs in they will see all of the modules that are available for the class that they are enrolled in. They then would click on a link that would take them to that module's test. What is the best way to do this? My module table right now has the following fields: moduleID, module_name, and module_num (This allows the teacher to order the modules in whatever order they wish.) Should I include another field, hyperlink, that directs the student to that module's testing page? Or is there a better way to acheive this?

Thank you in advance,

Ray
 
Old July 5th, 2003, 08:39 AM
Authorized User
 
Join Date: Jun 2003
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You could add another field that would have the hyperlink information or you could construct the hyperlink to use the moduleID:

That would allow you to post the hyperlink using already stored data.

Code:
Response.Write("<A HREF='http://www.somesite.com/somedirectory/" & moduleID & ".com'>Test Module</A>")


-Shay Shepston





Similar Threads
Thread Thread Starter Forum Replies Last Post
XML XSLT AJAX and Database Advice Pls newbieboobers XSLT 2 March 20th, 2008 08:53 AM
Advice sarah lee ASP.NET 1.0 and 1.1 Basics 2 December 26th, 2006 12:11 PM
some advice please? liquidmonkey Java Basics 1 May 4th, 2006 08:54 AM
Need some advice wariental HTML Code Clinic 1 March 25th, 2006 09:48 PM
Advice 95_rifleman VB Databases Basics 2 February 13th, 2006 08:15 AM





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