New Scripts | ASP | Tutorials & Tips

Shows how to create a text file using the File Scripting Object.

Learn how to delete records with an SQL instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.

There are a few different ways to connect to an Access database using a DSN-LESS connection. You can use the Access driver, an OLEDB provider connection, a physical path or a virtual path. Here is an example of each as well as a DSN-LESS SQL Server connection.

Learn how to edit records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.

Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.

Dropdowns or combo boxes are an excellent way to get input from a user. One of the biggest problems with user input is spelling and formatting. Here is how to use and populate dropdowns from a database.

As a website gets bigger it can become more difficult and time consuming to maintain. One way to help manage this is with the use of include files. Using includes will cut down on time by limiting the amount of code or html you will have to add to new pages or time spent updating existing pages.

Never worry about your copyright being out of date again.

A code snippet to display the last modified date for any given file dynamically. Every time the file is modified this info is written into the file. The FSO knows just how to read that for you.

This quick and simple tutorial gives you an quick idea on how cookies are set & read by your scripts. Cookies are a quick and easy way to add any form of interaction to your site this tutorial gives you a quick 101 on how to use them in your scripts. A tutorial worth a read for both beginners and advanced.

It is an often problem with database intergration when you use a reserved word. Often asked why a script does not work and it quite often comes down the the author setting a field name as a reserved word, confusing SQL and making debugging hard. To solve this problem here is a quick list of the SQL Reserved Words.

When faced with learning a new technology, it's common to try and reproduce the basic functionality you're used to in the old one. In doing that with ADO.NET and trying to reproduce the basics or the recordset object, this article discusses the new and many uses of ADO.NET's DataView object.

Step-by-step tutorial on how to upload files (images, text, other documents, etc) using plain ASP pages to the database. Every step has been explained in detail. Downloadable source code available.

This very important article describes in detail what you need to know to register / unregister ActiveX ( COM Component ) DLLs remotely using only plain ASP pages. Must read for all ASP developers. Everything has been explained in detail.

Overview and a quick example of the Len() function that calculates the LENGTH of a string.

Many times people will make the mistake of naming a database field with an SQL Reserved word. This is an easy mistake to make. It's hard to remember every single one. Here's a concise listing of SQL Reserved words to help you along.

There will come a time when you need to dice up a string which is all one word or a number. In this particular case, Split() won't work for you. This page explains how Left() Mid() and Right() work.

This example is a simple counter using graphics to display the numbers that will only show page views, not actual visitors. It uses the File Scripting Object to interact with a text file.

Step-by-step tutorial on how to display uploaded binary files from the database using plain ASP pages. Every step has been explained in detail. Downloadable source code available.

Often times it is necessary to take a string and dice it up in order to extract portions to be used for some obscure purpose. Enter the Split() function. Split is a very easy concept to grasp. Decide where you want to split your string and away you go.