Transaction Under Process

[Asim]

Hi
Does anyone know how "Trasaction under process" things work.I dont have any idea. You have seen in many website when there is searching we have a massage ..
pLease Wait...........While Searching., or when we submit some data we have the same message.

Thans in advance
Asim

[simflex]

The way I would handle this is have 2 pages:
search.asp.
I would select records from db into a recordset and deliberately select records that contain empty values.
then post back to search.asp, something like:
<form action="search.asp" method = "post">
Then I would do an if statement that says if the select statement does not return any values, then do perform another select within search.asp but this time, post to search2.asp like this:
<form action="search2.asp" method = "post">
Then on search2.asp have your message like:
<center>
<font face=verdana size=2>
Trasaction under process...
</font>
</center>

[Asim]

What abt when we have to insert the data into our database and this is more critical caz if user refreshs the page or cant wait for long then there will be a problem .I think if we refereh the page and redirect to our main display page it would be better and on trancastion page we can use a msg that "transaction under process", so now user will wait until page refreshes and redirect ,u like this idea.
Thanks in Advance
Asim

[simflex]

the method I demonstrated to you does not require any waiting time.
It is more fanciful than anything else.
Now if you are expecting your data insert to take forever, you have to look at your insert code more closely.
Normally, only search/update/list functionalities take longer.
But if you must use your method, then think of a progress bar in that case, check out this link:

http://www.atgconsulting.com/progressbar.asp