An end user will have an input form to pass 3 parameters to a store procedure which will take 3 parameters (Region,Order_num,Date). The result is a...

How It Works

Get an answer in three easy steps. Here's how it works...

Ask Your Question

1. Ask Your Question

Enter your programming question at the top of this page and click Get An Answer.

Pick Your Priority

2. Pick Your Priority

Tell us how quickly you want your programming question answered.

Get An Answer

3. Get An Answer

Connect with your programmer via online chat or telephone call.

Answer

Customer
An end user will have an input form to pass 3 parameters to a store procedure which will take 3 parameters (Region,Order_num,Date). The result is a report that is shown on asp page.Once this report is created I want to save it somewhere so if another person requested the same report, I can show that report and not run the store procedure again. If an end user requested a report that has not been created, at this time, the 3 parameters will be passed to the store procedure and prepare the report to the asp page. This is my notion, I do not know how to accomplish this, if you have any idea, please let me know Regards, Ali
Last updated
ken
Programmer
Ali,

Probably the easiest method would be to add a table to your database. The columns required in
the table would be the 3 parameters you mentioned, date/time created and a 'memo' field to
contain the Report.

When a user requests a new report, you would first check the Report table to see if has been
created within some pre-determined time period. If so then simply get the 'memo' field containing
the Report and use 'response.write' to display the report.

Good Luck,

Ken
Posted

quoteTestimonialsquote

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.

ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!

More Programming Questions...

Ask Your Programming Question & Get An Answer Now!