javascript - Order of events in asp classic when generating excel spreadsheet -
long time lurker...
short story long: i'm building on-the-fly spreadsheets asp classic , ms sql. i'll simplfy basics since issue isn't in creating spreadsheets or building forms. issue happens after spreadsheets created.
user specifies variables, order vars, display type (radio buttons, check boxes, text areas, drop downs, javascript form checking, , jazz) .
submission goes assembly asp classic page, grabs stuff out of database, either displays screen or uses addheader (both using various include files/sql views) bodge excel spreadsheet , ship file off user.
issue: when spreadsheet option specified, user experience have form (with of choices) remain in browser. after opening (or saving) spreadsheet file - user returns browser find form left it.
not problem me... client??? loves how works except they want form reset starting position.
i have looked @ (and tried on past 10 hours) (from javascript pop-under windows response.redirects) , stuck on intervene in process.
the client not want html reports open in new window , doesn't want separate form-set screen viewing vs spreadsheets. kind of limited in approach.
so somehow need find way determine spreadsheet has completed or form has been submitted in spreadsheet mode , refresh page form on.... sigh.
ideas????? clues???
this jquery plugin gives success , failure callbacks when downloading file.
so in success callback execute javascript reset form, , in fail callback display friendly error message if went wrong.
Comments
Post a Comment