Error Trapping the dreaded refresh

[Laphan]

Hi All

My problem basically is as follows:

1) User enters their details to create a new account in my db.

2) They press the submit, the system successfully creates their new account
and then displays a page saying 'well done you've created your new account'.

3) The doofus (or clever clogs) clicks the Refresh button, which in turn
submits the details back to the db and creates a duplicate entry in my db.
I don't have a duplicate account num, as the system takes the max last one
and adds one to it so really no errors are generated, but it does mean that
they have 2 accounts now.

As mentioned above, this scenario crops up when doing a New Account page and
when they've just posted their order via the shopping cart final page (shall
we say). The latter worries me because duplicate orders would cause a lot
more hassle.

I realise this may be a common problem, but I'm not sure what the best
method is.

Your help/advice on how to handle this would really be appreciated.

Rgds

Laphan

[Manohar Kamath [MVP]]

The key is to redirect the user to another page -- something that confirms
the creation of account. This way, even if the user clicks on refresh, you
won't have duplicate entries.

--
Manohar Kamath
Editor, .netWire
[url]www.dotnetwire.com[/url]


"Laphan" <news@DoNotEmailMe.co.uk> wrote in message
news:40c32551_3@127.0.0.1...

> Hi All
>
> My problem basically is as follows:
>
> 1) User enters their details to create a new account in my db.
>
> 2) They press the submit, the system successfully creates their new

account

> and then displays a page saying 'well done you've created your new

account'.

>
> 3) The doofus (or clever clogs) clicks the Refresh button, which in turn
> submits the details back to the db and creates a duplicate entry in my db.
> I don't have a duplicate account num, as the system takes the max last one
> and adds one to it so really no errors are generated, but it does mean

that

> they have 2 accounts now.
>
> As mentioned above, this scenario crops up when doing a New Account page

and

> when they've just posted their order via the shopping cart final page

(shall

> we say). The latter worries me because duplicate orders would cause a lot
> more hassle.
>
> I realise this may be a common problem, but I'm not sure what the best
> method is.
>
> Your help/advice on how to handle this would really be appreciated.
>
> Rgds
>
> Laphan
>
>

[Laphan]

wundabar!!!

thanks Manohar

Manohar Kamath [MVP] <mkamath@TAKETHISOUTkamath.com> wrote in message
news:eH5fwJ#SEHA.2908@TK2MSFTNGP10.phx.gbl...
The key is to redirect the user to another page -- something that confirms
the creation of account. This way, even if the user clicks on refresh, you
won't have duplicate entries.

--
Manohar Kamath
Editor, .netWire
[url]www.dotnetwire.com[/url]


"Laphan" <news@DoNotEmailMe.co.uk> wrote in message
news:40c32551_3@127.0.0.1...

> Hi All
>
> My problem basically is as follows:
>
> 1) User enters their details to create a new account in my db.
>
> 2) They press the submit, the system successfully creates their new

account

> and then displays a page saying 'well done you've created your new

account'.

>
> 3) The doofus (or clever clogs) clicks the Refresh button, which in turn
> submits the details back to the db and creates a duplicate entry in my db.
> I don't have a duplicate account num, as the system takes the max last one
> and adds one to it so really no errors are generated, but it does mean

that

> they have 2 accounts now.
>
> As mentioned above, this scenario crops up when doing a New Account page

and

> when they've just posted their order via the shopping cart final page

(shall

> we say). The latter worries me because duplicate orders would cause a lot
> more hassle.
>
> I realise this may be a common problem, but I'm not sure what the best
> method is.
>
> Your help/advice on how to handle this would really be appreciated.
>
> Rgds
>
> Laphan
>
>