Slapping the BOTS around

[Clark]

OK, I did this work-around to give people a total for the things they are
signing up for without using Javascript or custom ASP. Interested in any gotchas
you see.

What I did: On submitting the signup form, you are directed to a confirmation
page where you are presented with what you signed up for and the total due that
come from querying the database.

To get that information on the confirmation page, I used the DRW to bring up
the last record in the database (since that would be the one they just
submitted). Reason I did it that way is I didnt know how to pass information
about them from the signup form to the DRW. I was really not sure if the server
would serve up the record that was just now entered, or the one that was the
previous last record

It seems to work. The only potential snag I can think of is if someone else
entered their data between the time you entered yours and your confirmation page
came up, in which case the last record would be theirs, not yours. Small
probability.

You can see this and try it at:

http://www.homepagedoctor.com/marshallreunion/eventregistration.asp

What do you think?

Clark

 

[p c]

It looks fine. What specifically are you asking comments for?

 

[Clark]

It looks fine. What specifically are you asking comments for?Yes, I know it is working but the approach I used is a little questionable in my
mind and I was looking for confirmation that the approach is solid.

I mean, submitting a database record via a Form and then on the confirmation
page immediately calling up the last record.

Suppose the server was bogged down -- could the confirmation page you get after
submitting the form conceivably come up before the record from that form is
written to the database? Or would that be impossible because of how the server
manages database connections?

I hope the question makes sense ---

 

[Thomas A. Rowe]

You can not count on the last record being that of the current user, you need to request the record
by some means, such as learn to retrieve the record id or assign account number, etc. as the records
are created,

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Clark]

Thanks Tom. I just found on Steve Travis' Thingamujig site a way to make the
autonumber ID field of a new record available as a confirmation field. I'm going
to see if I can make use of that. Seems like if I can firgure out how to use
that to drive a query on the confirmation page I should be all set ---