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



Windows Technology Windows Technology
15 Seconds
4GuysFromRolla.com
ASP 101
ASP Wire
VB Forums
VB Wire
WinDrivers.com
internet.commerce internet.commerce
Partners & Affiliates
ASP 101 is an
internet.com site
ASP 101 is an internet.com site
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
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).


Samples

Home |  News |  Samples |  Articles |  Lessons |  Resources |  Forum |  Links |  Search |  Feedback

Internet.com
The Network for Technology Professionals

Search:

About Internet.com

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