ASP 101 - Active Server Pages 101 - Web01
The Place ASP Developers Go!

Windows Technology Windows Technology
15 Seconds
ASP 101
ASP Wire
VB Forums
VB Wire
internet.commerce internet.commerce
Partners & Affiliates
ASP 101 is an site
ASP 101 is an site
Internet News
Small Business
Personal Technology

Corporate Info
Tech Jobs
E-mail Offers

ASP 101 News Flash ASP 101 News Flash

Script Output:

Running the stored procedure: GetNameInfoById.

Passing it one parameter:
Id = 1

It returned a recordset which I used to print out this name: Andrew Fuller.

ASP HTML Download            FAQ

ASP.NET Version

After my recent sample on SQL Server stored procedures, I got a number of requests for something similar in Access. While you won't get the same performance benefits you do with SQL Server, you can use stored queries in Access to move the query text out of your ASP code.

While they don't give you the performance boost you get with SQL Server's stored procedures, they can get you started developing better solutions by removing your database specific code from your ASP scripts. This can make switching databases easier should the need arise. It might also help alleviate some of the problems people have been having with SQL injection attacks.

The database is a slightly modified (to include the query) version of our standard sample database and can be downloaded from here (160 KB).


Home |  News |  Samples |  Articles |  Lessons |  Resources |  Forum |  Links |  Search |  Feedback
The Network for Technology Professionals



Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers