[thelist] ASP/VBSCRIPT: best way to verify successful record insertion

[Chris W. Parker]

yes. that is exactly what i'm talking about. the problem i was running
into though was that of uniquely indentifying the registrant. that's why
i had the idea of the session variable.

a session varaible would uniquely identify the person more than there
name could since two people can have the same name. (and that goes for
almost any other field that i might need to record.) we deal with police
and with the last event it happened a few times where a captain signed
up his whole team changing only the name and rank of the registrant and
leaving email, phone number, address, etc. the same.

ok fine, it's not likely that two Steven Kurdings will sign up at
exactly the same time. so then does that rule out the likelihood of
retrieveing the wrong record based name? or maybe i should base it on a
few fields? name, phone, address, rank?

what would you suggest?


chris.

> -----Original Message-----
> From: Tom Dell'Aringa [mailto:pixelmech at yahoo.com]
> Sent: Monday, August 19, 2002 4:30 PM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] ASP/VBSCRIPT: best way to verify successful
> record insertion
>
>
> Chris,
>
> Maybe I don't understand fully - but after the user submits the
> registration form, I would have immediately done a lookup in the DB
> and return their information to them on a confirmation screen. This
> is your name, this is your blah blah blah.
>
> If you are successfully returning a confirmation page, you have the
> data in your DB. Then when you go to make packets from your DB, you
> have them. If the confirmation page errors out, you know there is a
> problem...
>
> Not sure if I'm shooting at what you are talking about..
>
> Tom
> --- "Chris W. Parker" <cparker at swatgear.com> wrote:
> > hi.
> >
> > my company recently did an online registration for an event we
> > hosted.
> > we had quite a few people complain that they signed over the
> > internet
> > but had to reregister since we did not have a registration packet
> > for
> > them. something went wrong when they filled out the form and
> > clicked
> > submit and i have no idea what.
> >
> > what i'd like to know is how can i best verify that their
> > submission was
> > recorded? i'd like to notify them that they will receive an email
> > after
> > they sign up and that if they do not receive an email within an
> > hour or
> > so, they should call us or reregister because it did not work.
> >
> > what i thought i could do was record their session variable and
> > then
> > immediately look it up again. if i find a record with their
> > variable
> > then that means it worked and i can send the email, if i don't find
> > it,
> > then it didn't work and i should notify them that there was a
> > problem.
> >
> > is this the best way to do it? is there an easier way? are there
> > any
> > implications with how quickly i can turn around and check for a
> > record?
> > do i need to wait a second or two?
> >
> >
> > thanks,
> > chris.
> > --
> > For unsubscribe and other options, including
> > the Tip Harvester and archive of thelist go to:
> > http://lists.evolt.org Workers of the Web, evolt !
>
>
> =====
> var me = tom.pixelmech.webDeveloper();
>
> http://www.pixelmech.com/
> http://www.maccaws.com/
> [Making A Commercial Case for Adopting Web Standards]
>
> __________________________________________________
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !
>