I have a long query/process that has to happen to get certain data from my database. My users are assuming that since it is taking so long that it doesn't work. I want to be able to display a message that says "Please Wait" until the query is finished.
This is my process thus far,
FORM -> URL QUERY -> Redirect Page -> URL QUERY -> PAGE WHERE QUERY/PROCESS IS EXECUTED
I wanted to use the redirect page to display the message, so I tried using the <CFFLUSH> tag, but it doesn't seem to complete the <CFLOCATION> that directly follows it:
Please wait, thanks.
The "Please wait, thanks." displays and that works, but the process doesn't run. If I take out the flush I don't see the "Please wait, thanks" and the process runs, but it looks broken.
Any help is appreciated. Thanks.