Connections, Commands and Procedures is a sample chapter from Professional Active Server Pages which discuss in depth all the issues related with establishing connection to a database to the carrying out of commands and procedures.
Displaying Records Using Stored procedure ASP / Database Integration
We will get results form a table using stored procedure. Stored procedures work faster and increase the performance. Stored procedures stored at SQL servers and we can call them in an ASP file.
Functions and Subprocedures ASP / Getting Started
Functions and procedures provide a way to create re-usable modules of programming code and avoid rewriting the same block of code every time you do the particular task. If you don't have any functions/procedures in your ASP page, the ASP pages are executed from top to bottom, the ASP parsing engine simply processes your entire file from the beginning to the end.
Maximize Your ASP Performance ASP / General Development
Active Server Pages give great performance, but you can make them even faster with a few tweaks to your code and database connections. Here's a detailed tutorial on how to refine your scripts and ASP features for maximum speed.
SQLServerTools Object ASP / Database Integration
This example was easy Get a list of all current tables in the database created by your's truly, get a list of dependent stored procedures for each table and do it all in a stored procedure.
Counter in ASP ASP / Counters
A hit counter is an essential part of a site to know how many people are coming to site. Here is an easy way to make a counter. All you need is access to ASP and be able to give a write access to a directory. We're going to save the amount of hits in a .txt file so that we won't need to worry about database connections.
File DSNs - Use and Reuse ASP / Database Integration
Many a time, you are confronted with creating a system DSN for use with ASP. If you have an ISP account, this might take time and more than sometimes - money. This article describes how to use File DSNs and save time and money. Also, you can reuse these DSNs and thus, with some modifications, use the same DSN for as many database connections.
Loops within Loops: Coding an ASP-based Bulletin Board ASP / Scripts
This article provides an easy way to list nested forums. It does have some drawbacks, though. For starters, there is an upper-bound on the number of nested replies a message can have. In this example, the number is 12, although this is configurable. Furthermore, this approach is not the most efficient approach, and could be streamlined using stored procedures and fewer ADO objects within the code.
Fun With Stored Procedures ASP / Database Integration
A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others ... A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates... as an added bonus, it further separates the sql statement from your asp leaving you with more readable code. So let's get on with it.
Create a Fully Functional, Multifeatured ASP Shopping Basket ASP / Scripts
This article uses the terms "shopping cart" and "shopping basket" interchangeably. Also, to define "shopping cart," I am referring to the aspect of the Web site that allows shoppers to enter products and modify them in their cart. This does not include the checkout process, which in many cases includes on-line credit-card verification and billing procedures.
Control Structures - Introduction ASP / Getting Started
A control structure is a programming structure that allows your script/program to make decisions based on a certain set of commands and on the information provided. Controlling the flow of your program allows you to make more flexible programs - you will struggle to find a complicated program without a control structure in it.