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

Hi,

Usualy, instead of writing the answer at the end of the server-side
processing it's recommended to redirect the response this way :

<%
set val ...
val.Exec...
'Ok it's done

response.redirect "ThisIsDone.htm"
%>

regards,



"Laphan" <news@DoNotEmailMe.co.uk> a écrit dans le message de
news:40c32553_3@127.0.0.1...[color=blue]
> 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[/color]
account[color=blue]
> and then displays a page saying 'well done you've created your new[/color]
account'.[color=blue]
>
> 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[/color]
that[color=blue]
> they have 2 accounts now.
>
> As mentioned above, this scenario crops up when doing a New Account page[/color]
and[color=blue]
> when they've just posted their order via the shopping cart final page[/color]
(shall[color=blue]
> 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
>
>
>
>[/color]

Laphan, please don't multi-post.

--
http://www.aspfaq.com/
(Reverse address to reply.)




"Laphan" <news@DoNotEmailMe.co.uk> wrote in message
news:40c32553_3@127.0.0.1...[color=blue]
> 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[/color]
account[color=blue]
> and then displays a page saying 'well done you've created your new[/color]
account'.[color=blue]
>
> 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[/color]
that[color=blue]
> they have 2 accounts now.
>
> As mentioned above, this scenario crops up when doing a New Account page[/color]
and[color=blue]
> when they've just posted their order via the shopping cart final page[/color]
(shall[color=blue]
> 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
>
>
>
>[/color]