Top Rated Scripts | ASP | Tutorials & Tips

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.

Never worry about your copyright being out of date again.

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.

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.

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.

How do I get the Unique ID or Auto ID of the record I just entered? The solution is really quite simple.

Active Server Pages - What it is, why we use it and how to connect, post and retrieve data from a database.

This article describes how the author (Phil Baines) got started with ASP and how you can too. It also offers some scripts to try out yourself and links to the useful sites.

Tutorial and sample codes to calculate the distance between two locations. Free sample source codes in PHP, ASP, ColdFusion, C/C++, C#, Java, Perl, Visual Basic and Javascript. Longitude and latitude for United States ZIP Code and Canadian Postal Code are available in database subscription.

For many years we have heard about the impending death of URLs that are difficult to type, remember and preserve. The use of URLs has actually improved little thus far, but changes are afoot in both development practices and Web server technology that should help advance URLs to the next generation.

In this article we are going to try and provide some ideas for you to reduce those calls to the help desk. In this project we created a help desk portal, this portal pretty much has a main page that you can go to download patches, virus definition files, and manage account unlock information. Calls to the help desk for unlocking locked accounts accounted for a large percentage of calls, so in order to streamline the process we created an application that tied in with the intranet user portal.

In this article, we will look at a list of metacharacters. You may create your own pattern using these metacharacters

The Querystring explained in easy to understand terms. This tutorial is written primarily for the beginner ASP developer and includes diagrams.

If you have a new feature on your website, you can put up an image or text to proclaim how new the feature is. The image, or text, will automatically "fade" in intensity as the days go on.

Tutorial: Determine if a client and user agent meet the requirements to deliver full 5.1 surround sound to your web visitor. Topics covered include client machines, user agents, media players, http headers and MIME types.