Top Rated Scripts | ASP | Tutorials & Tips

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.

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.

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.

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.

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

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.

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.

This 9-page tutorial shows you how to add discussion forums to your web-site. With support for an unlimited number of forums and messages and easy administration learn how you can add discussion forums to your site.

ASP pages are executed on the fly by a server when they are requested by a visitor. Because they are not compiled, ASP scripts are slow and hold up the processing of an html page. This results in people leaving your site and severely reduces the enjoyment that your asp apps can provide. This short tutorial provides a few tips to increase the execution speed of your asp programs.

This is a couple of simple ASP scripts demonstrating how to rotate banners in random order. It makes use of JavaScript's Math.random() function.

This is an article on executing all or none database queries using ASP-Database transactions. Must read for ASP-Database developers. Sample Database and Code available for download.

This hands-on tutorial explains how to develop a simple SQL-driven web site in just minutes. Topics include: Our Database Design, Creating a Data Source, Inserting A Tip Into Our Database, Displaying and Deleting Tips, Searching the Database, and Displaying the Tips.

Have this short program around so that you can quickly see what columns and what data are in your database. Here you will see some of the common methods and properties used to limit the results from your SQL query. Using a simple form that takes a table name and a submit button, and you can easily display increments of the table data. Full source code available.

You all must have seen and done stuff with the RecordSet object, infact everything is done with the RecordSet object. Now, this acticle explains how to use GetRows to page through the records that you recieve from the SELECT. It's much faster than MoveNext, because it closes the database connection immediately whereas MoveNext loops through the records with the overhead of the database connection. Plus GetRows let's you count the records correctly!

The checkbox object is coded along the same lines as radio buttons, however each checkbox must get its own unique name since the state of "checked" or "not checked" will be passed to ASP for each box. Remember that you can set more than one option to be checked. Complete source code provided for the example.

Building an upload file mechanism on a Web server can often require using a costly DLL. Tiago Halm's article shows you how to upload a file using only Active Server Page (ASP) code and Internet Explorer. Sample code is provided.

The browser can do a great many things, but it has a limit of 216 colors that can �safely� (without dithering or color washout) display. Fortunately, there are many ways that you can display all the color combinations in the browser safe color palette. By placing the six possible values for color (00,33,66,99,CC,FF) in an array and nesting three for next statements with values one through six a table with all the color codes will neatly be displayed in a table.