Most Popular Scripts | ASP | Tutorials & Tips

Develope reusable code with VB make it dlls and use it in your ASP as third party objects. Knowledge in VB programming is necessary.

Learn installaing and configuring ASP scripts and COMponants in your web server in easy steps. No need of programming knowledge.

Explains the basics of using a query string to send information to different page.

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.

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.

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.

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.

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.

There are many ways to use arrays. This page shows a couple of quick examples for using arrays in ASP.

A short tip on passing info between pages via a query string.

There are several different ways of displaying times. Using FormatDateTime and DatePart functions we can manipulate the time in many different ways.

Many times we need to perform an action or display something different based on some different parameters. Using If ElseIf End If is one such way to do this.

Many times we need to perform an action or display something different based on some different parameters. Using select case is one such way to do this.

This is the second article in this series. This article mainly deals with SQL Joins and SQL sub-queries. Both of these are extremely useful SQL constructs and should be learnt by all beginners.