Displaying message before database connection

Hi,

I'm fairly new to ASP so if this is really simple I apologize in advance for my stupidity.

At the top of my ASP code a connection is made to a database and some data is pulled back. All I need to do is put a message at the top saying Please wait but I can't seem to get the text to appear before the database code executes. In VB I would issue a simple .refresh on the label control but there doesnt seem to be a similar refresh function in ASP.

Any ideas?

Thanks.

By Default in asp, the buffer object is set to false, that means the processed html is only returned when the execution is competed. So thats why you dont get to see your wait message.

You can set the buffer to true buy putting response.buffer = true at the top of your page.

then
response.write "whaterverere"
'more response.write
response.fulsh

Response.flush will now force the asp page to print whatever is in the buffer.

Hope this helps.

Danial

Excellent! that did the trick!

Thanks a lot!