It has to be possible

[David Laplante]

I have this small VB Application wich acts as a CGI generating HTML and accessing an MS-ACCESS Database. the thing is when a user creates a record and then presses REFRESH or F5, the record (or action he was doing) repeats its self as long as he refreshes...

Is there a way to prevent that ??

[David Laplante]

Please don't tell me I have stomped everyone...

I just want it to do like in hotmail when you press back...

and in some places (still in hotmail) when you refresh...

[Psyrus]

David,

I am a little unclear as to what you are asking. Do you mean that you are refreshing the HTML page or the recordset.

Maybe try closing the recordset and setting it to nothing after the action is completed then opening up a new one when the next action is to be completed. ???


Psyrus

[David Laplante]

The application is for creating cheques via the web. One user creates it and then two other and different users have to approve it.

A list of cheques to approve is displayed with a APPROVE button for each Cheque.

When the first user clicks on APPROVE, the application is launched and his user name is enter in the record as a first approval and the list is diplayed again showing all the other cheques still to be approved (but not the one that was just approved). Right then. At that moment when the cheque he just approved is not in the list, if the user refreshes the page (F5 or Refresh from browser menu) his name is added as a second approval.

this and some other similar problems are why I want to prevent refreshing the page.

Any ideas ?

[Zaf Khan]

are your storing the values in seperate variables or using the same common one?

DocZaf
{;->

[David Laplante]

I am not very familiar with CGI applications... I have been given this VB module that (i think) emulates a CGI... The way it works is that each time the user presses a button on the page, the application is relaunched and an action is taken depending on the value of the button and the fields entered by the user, or the one that I need to remember are stored in hidden fields on the web page...

in that manner, if the user presses back (or refreshes the page) then the application is run again using the old values stored in the web page and, depending on what the page did (Adding a cheque to the database for example) it does it again...

I know that I could check to see if a cheque exactly like it alreday exists in tha database but since I have to store the date and time that the cheque as been created, I will never see an exact match and also it IS possible that a user wants to create 2 similar cheques... So I think that checking the existence of an exact match is not a safe bet when creating cheque with a large amount.

Hope this cleared it up a bit.

Do you have an idea?

[Zaf Khan]

Okay I get the gist of what your saying,
Now post your IFFY code and lets see what we can do

DocZaf
{;->

[David Laplante]

I'm sorry ? what is IFFY ??

if you want ... i can email you my project