Most Popular Scripts | ASP | Tutorials & Tips

Allowing multiple choices of data elements enables people to customize views of your data and adds value to your applications. In this sample code, user inputted choice(s) are added to the basic sql statement to draw them from the db. Since the input from the dropdown menu comes through comma delimited it is simply written into the statement without modification. Two simple for next loops determine which elements are part of the record set and displays them accordingly.

The help system presented in this article is self contained and can be updated and altered without impacting the original Web application. The help icon in the Web application dives into an application system for the help option. Each Web page has its own separate help page with a database that contains one row in a table for every calling Web page. Sample code is provided.

Automated content management is a must for many web sites. It's difficult to provide fresh new content without a standard automated system. This article discusses how to generate a general submission system, as well as how to manage the work flow, all with examples.

This page demonstrates the capabilities how to write an ASCII comma-delimited file from a SQL statement using ASP.

Step by step tutorial on creating a Java COM component which accesses and uses ASP Intrinsic Components. Sample Project files, Component and ASP code available for download.

In depth article on showing records in a page by page fashion with 'first page','next','back' and 'last page' links at the bottom to navigate through the records. Sample code and database available for download. Online demo also available.

Learn how to search and sort the records through the database. Step by step tutorial with Sample code and database available for download. Online demo also available.

This article is primarily for Active Server Pages (ASP) developers who would like to take their ASP skills a step further. By bundling ASP code into server-side components, developers not only increase Visual Basic functionality and ASP speed, but also find a marvelous way to encapsulate and protect their ASP source code. This tutorial will walk you through the process of developing a very simple server-side ActiveX ASP component. The emphasis will be on the steps it takes to produce a server-side Dynamic Link Library (DLL) file, not on complex ASP scripting or advanced VB code.

This lesson teaches you how to make a random quote of the day. It reads the quotes from a textfile (for easy maintenance), and displays it. Full source code is available for download.

Storing frequently used lookup data in a database is a great idea (e.g. order status codes, state names, etc.) that saves tremendous amounts of time in design and maintenance. However, retrieving that data from the database every time it is needed is very inefficient. This article describes how to use Application variables to cache frequently used lookup data in memory to achieve lightning fast access times.

If you want to add a guest book to your site, then this article is for you - it contains full source code and the necessary Access database to get up and running immediately. A complete introduction to ADO is provided.

This script will open all HTML pages within the specified directory, reduce the file size of your html pages, and the files will be saved back. You may password protect the script, and it will allow a faster transmission of the page. A good script to learn how those task are perform.

This tutorial shows you how to create a file archive on your site using the built-in File Access Component. You can easily customize how yout page looks. Full source is available for download.

Global.asa is the "dark file of ASP" and many don't even know that it exits. The truth is that Global.asa can be a powerful tool, but it's not as good at it should, and is often difficult to master. The following lesson give you a brief guide on Global.asa.

You can connect to an Access database within an ASP page with different methods. This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine.

Multiple level select boxes tackled with hierarchical data! This sample illustrates the concept using a hierarchy consisting of geographical region, country, and state data. The code expects a system DSN by name "Hierarchy" and accesses the database using the user id "sa" with a blank password. The database is created in SQL Server 7.0.

No one likes to see 404 pages and it's even worse when you find one on your own site. This tutorila explains how to make the 404 page useful to the user and notify yourself so you can fix them ASAP.

This is a quick introductory guide to ASP technology. Covers what it is, how it works, how to configure your computer to run ASP without a server, and creating system DSN for MS Access database.

This article describes how to build a very powerful, potentially destructive application using the File System Object. It should never be implemented in a production environment without ensuring that proper security precautions have been taken to maintain the integrity of the data contained on the web server.

As a web site grows, finding content on the site becomes increasingly difficult. To combat the difficulty of finding relevant information on a large site, many developers turn to writing a search engine for their site. This article discusses how to implement such a system using Active Server Pages and SQL Server.