New Scripts | ASP | Tutorials & Tips

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.

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.

This tutorial shows how to implement a catalog site that is build with Active Server pages and SQL Server. Along with the implementation there is source code and a discussion of the advantages and disadvantages of creating a catalog site that gets its content from a database. Included are pages for displaying products, creating a menu page, category page, and running a search across a database.

This article explains how to control web application access by validating the user�s login and password against a database using Active Server Pages. Once validated the IP Address of the user is ensure that the user has access to the database.

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.

This short tutorial explains how to to upload a text file and load it into your database using ASP. It uses a sample of the space-delimited file for an example.

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.

This is a quick and easy guide to building an authentication system in ASP. First, it explains Authentication: What it is, how you work with it, and what options are currently available to you. Then, it explains each choice in more detail to help you decide which is the best way for you to authenticate your web users.

Flash allows you to create zippy, vector-based animation and interactivity in a small ActiveX control, and ASP allows you to create dynamic HTML content on the fly. This tutorial explains how to use ASP in the creation of zippy, vector-based Flash content on the fly.

There are a number of ways to have users input dates into your application. Dropdown menus are the preferred method employed as there will certainly be less error checking on dropdown input as compared to textbox input. Utilizing the date() functions the current date (or any date you prefer by adjusting the date value) can easily be made the pre-filled selected value. Here you will find two examples: one that displays the current date with a range of days prior, and the other that displays the current date out of all the dates in a range of years.

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.

Providing search capabilities to a db enables users to query on whichever element you target them to. However allowing users to target which portion of the db they would like to query gives extra value. In this example, utilizing our db of US States (state, statename, and capital) the user can search in any of three fields (by dropdown menu input) rather than the application targeting one specific table element. Note: The db only has 50 observations in it, so it is better to search on single or double letter combinations.

Outputting data from two tables is almost as easy as displaying from one. This example utilizes two tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each state was admitted into the union (year) and the numeric order they entered in (entered). The second table (state_capitals) contains state abbreviations (state), state names (state) and state capitals (capital). The where statement looks to make a match on the field that each table has in common to ouput the correct capital with all the info from the state_order table.

Cookies enable you to write text directly to a users computer. This can be used to easily recognize if a user has been to your site before or used to prevent multiple entries in to forms. This example will take any input you type in and write it to a cookie. A hyperlink to the same page is created to demonstrate on subsequent visits (within 3 days) the user will see their input rather then the text input box.

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.