Can a Confimration Field Value be used is asp coding?

[Dave]

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

 

[Thomas A. Rowe]

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)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


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

 

[Kevin Spencer]

You can do anything with ASP. You can NOT do anything with the FrontPage
Database Results Wizards. I believe Tom is correct. You will need to "roll
your own" ASP to do this.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

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

 

[Dave]

As I play with this I see that you are correct.

How do I start, where is a good location to see simple code with forms and
Databases.

Thanks Tom!

 

[Thomas A. Rowe]

Dave,

I couldn't find any examples for actual class scheduling, so I started from scratch with the
exception of the user registration and login, which I already had coding from prior projects for
that part.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Kevin Spencer]

Hi Dave,

You may want to have a look at the tutorials, articles, and sample code from
my web site: http://www.takempis.com

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.