I have a stored procedure that needs to be executed via an ASP page.

The SP does a number of tasks, mainly comparing a local table against a

linked server table, and updating/inserting/­deleting where necessary.

It does this on 4 tables, one of them being fairly large, which will

keep on growing.

I have constructed the ASP page, made an animated GIF for the fake

progress bar, and then inserted the command to run the SP.

I then check the return value and if its 0 the page is redirected to a

results page which shows a table.

When I run this page I don't get to see the animated gif, the page pauses

until the SP is complete and redirects direct to the results

page.

How can I make the page load the animated gif first, and then once the SP

has run and is successful redirect?

<img src="progress.gif" width="150" height="150" />

<p>Please wait, upload in progress...</p>

<%

set cmUpload = Server.CreateObject­("ADODB.Command")

cmUpload.ActiveConn­ection = MM_aclv4_STRING cmUpload.CommandTex­t =

"dbo.updateWebshop"­

cmUpload.Parameters­.Append cmUpload.CreatePara­meter("@RETURN_VALUE­", 3,

4,2)

cmUpload.CommandTyp­e = 4 cmUpload.CommandTim­eout = 0 cmUpload.Prepared

= true cmUpload.Execute()

%>

<% If cmUpload.Parameters­("@RETURN_VALUE") = 0 Then

Response.Redirect("­results.asp")

Else%>

<p>Error Code: <%= cmUpload.Parameters­("@RETURN_VALUE") %></p><% End if

%>

Have you got Buffering turned on? If so, put a Response.Flush after the img

tag, but before the command Execute call. So long as you're not inside a

table then the browser should render what has been sent up to that point.

Response object error 'ASP 0156 : 80004005'

Header Error

/webshop/upload.asp­, line 26

The HTTP headers are already written to the client browser. Any HTTP

header modifications must be made before writing page content.

Any idea how I can get pass this hurdle?

Dooza wrote:

I ended up using some javascript instead:

<img src="progress.gif" width="150" height="150" /> <p>Please wait,

update in progress...</p>