Most Popular Scripts | ASP

Paging is basically querying a database and presenting a page full of the query's results. In ASP and SQL Server programming, there are three approaches to paging. This article compares the approaches and explains which one is the most efficient when dealing with very large sets of data.

It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedence? This article will answer these questions.

If a user doesn't find what they are looking for in the first couple clicks, the majority of them will move on to greener pastures. So how do you give the user exactly what they're looking for? This tutorial will show you how. Full source code is also available for download.

Aleza is an extremely functional marketing oriented resource management system. You may index not only resources but also images, articles, downloads.

This is an ASP GuestBook application. It offers an Admin section that will allow you to edit or delete any of the entries. It also logs the IP Address of the user when they submit an entry but will only let the Admin see the IP Address. The guestbook is available for SQL Server 7 or Access 97.

Here is a sample code that allows you to connect to an Access database without DSN Connection, Using MapPath Function of Server Variables.

This article shows how to generate random records from the database. Also explains how to generate random numbers. Sample Database and Code available for download.

picME is a purpose designed JPEG file creator which can be used to generate pictures for a "What picture is this" type web game. picME will generate 1 thumbnail file and 1 modified version of the original photo which highlights where the thumbnail was taken. Also, two additional ASP files are created by the program, these can be used with your own scripts or programs to display the pictures.

This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. 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, and it further separates the sql statement from your asp leaving you with more readable code. This tutorial describes: What is a stored procedure?, Writing stored procedures, Getting the stored procedure into the database, Calling stored procedures in ASP pages, and Modifying and removing stored procedures.

This application allows you to track a variety of site statistics, including hits per hour/day/week/month, IP address of hits, and browsers used.

This introductory tutorial will teach you the basics of vbscript, ASP intrinsic objects, how to call ASP intrinsic objects and make use of them and what makes a .asp page different from a .htm / .html page. After the completion of this tutorial you will be able to start writing your own .asp pages.

Are you interested to know who came to your site? at what time? and what was the referring URL. Here is an example how to make a Log file for an ASP page to keep track of users on your site. This Example use a text file to write user information.

SA-FileUp allows users with a web browser to transmit files from their local hard disk to a Microsoft IIS web server. Files can be of any format, such as Word documents, images or plain text. Developers can use SA-FileUp to receive and process user input, while staying within the context of their Active Server application. SA-FileUp also includes file download and file management components, which allow you to simply and easily download files from the web server to the user's browser, manipulate files, change ACLs and permissions, and register DLLs, all in a single, easy-to-use package.