Dave,
The best long term approach would be to learn to code your ASP by hand, then you would have more
flexibility and thereby eliminate most of the FP database component limitations.
I just complete a project with class registration, basically users have to login, then they can
select their classes. The classes are stored in the Class table, and when the user select the class,
the user's ID, Class ID and date are then stored in a Schedule table. When the user select the
Review function, their ID is use to retrieve all of their classes from the Schedule table which is
based on the Class ID shows the Class Title, Date, Start/End times and the room location, etc. from
the Class table.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
"Dave" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
This concept needs to be repeated in several places on the page. If I can get past one concept, the
others will be repeated code.
The user is to select a training class from a drop down.
The drop down is populated from a database CLASSES which contains ClassID Class Date
ClassID is a unique number which I am using to drive other pages including the confirmation page.
Class is a description of the course
Date is the class starting date
On the registration page I am using a dropdown populated by this CLASSES database and passing then
the CLASSID to a Registration database.
The problem is the confirmation page. I want the user to see all of the information they entered and
convert the ID into Class & Date. The user won't remember what the ID means from page to page.
I have two approaches on the confirmation,
1. I can pass all of the information to a verify page and then to the database (a lot of coding
especially if there are changes) and I have problems with spaces such as the user enters Dave Smith
and the value returned is Dave
2. I can pass the information to the database and to a confirmation page the with the information
user can understand.
This is the problem - that ClassID passes through but the user doesn't relate to a number they need
to see the Class Description and the Start Date
I have tried the DRW wizards to show the results, I have tried converting ClassID into usable asp
info on a confirmation page without success. I can see that Confirmation Field info which is shown
as a web bot but is not shown in asp language, thus the question
Can a Confirmation Field Value be used is asp coding?
Any help or best practices would be helpful.
Dave
Similar Threads
