I am building a website in ASp and i want to Create a form with two drop down lists; one for background colour, one for font colour. I want the User to be able to set the colour of both using drop down list and press submit.
TBut I want the form to submit to a separate page which should then say "Your settings have been applied" and the background and font colours will be the ones the user had selected from the drop down list. Code:
I'm writing an ASP page where the user can specify criteria for an online report that might take so long to generate as to justify rather sending the result as a CSV file by email.
I'm looking for ideas / best practice to manage the request for the CSV.
What I already have is ..
1. The ASP form that collects the report criteria.
2. An MTS object that receives these criteria and builds a matching recordset, and parses the results into a report (HTML format/CSV/whatever).
3. Also, the MTS object uses CDONTS (NT4 server still) to prepare an email and attach the parsed report as a file.
The problem is: when the user requests an email, I want control to immediately return to the ASP page so that the report can be prcessed and emailed in the background. Otherwise, what's happening now is that the user has to wait for the whole recordset to be processed and emailed, before the ASP page returns control to him!
What I don't want to do is: go and write a record to a database table, which some sort of polling app will pick up separately and generate the email ....