New Scripts | ASP | Tutorials & Tips

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.

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!

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.

Setting up a simple file downloading system with VBScript and ASP is no sweat. The primary use for a system like this is to allow downloading of any TEXT based file that would normally be served via a client's browser and be unable to be downloaded. A secondary use is to allow download access to directories outside the public server space or a hidden directory within the website. This tutorial shows you how. Full source code available.

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.

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.

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 is an article on using Recordset. It uses GetRows method to speedup database access. One of the fastest ways of displaying database records with ASP. Sample Database and Code available for download.

This tutorial shows how to quickly create and track multiple-choice surveys using our XML-based Survey Server for IIS. It uses XML to store surveys, XSL to generate different presentations, and ASP to manage all the processing to create an extensible engine for creating multiple-choice surveys.

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.

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.

Want to add value to your current search? Allow your users to search from within search results. As databases grow the necessity for the user to continually narrow a search to the item that they truly want will grow also. The following example utilizes a db on U.S. State capitals. Upon the first search two radio buttons will appear indicating a search (default) or a search within the current results. Searching within the current results will take the first search and add it to the new search and so on.

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.

One of the most powerful enhancements for any site is to establish community and personalization features. In our new series, we are going to demonstrate how to add community and personalization features to your web-site. The first step to reach this goal is to allow user registration. In this first article, we show you how to add user registration to your site using SQL Server and ASP.

This article discusses how the "Print this Page" option works. (The "Print this Page" option turns articles into a printer-friendly version, removing the menus, header graphics, and advertising.) If you are looking to add a printable version of your Web pages on your Web site, be sure to read this article.

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.

A very important coding method to understand when developing ASP pages is the page that submits to itself. This technique is very powerful and can drastically reduce the number of files you have to maintain and the number of places in which you need to make changes when maintaining code. The concept is simple. Using forms, set the action value to the URL of the page in which the form resides. Then use ASP code to determine what the current state of the page, and present the proper output to the user.

A function that calls itself repeatedly, satisfying some condition is called a Recursive Function. Using recursion, we split a complex problem into its single simplest case. The recursive function only knows how to solve that simplest case. You'll see the difference between solving a problem iteratively and recursively later.

This tutorial provides introduction to XML and then moves on to create an XML page. Step by step instructions are given to read the data from XML file using ASP pages. Sample Code and online demo available.