Author Archives

  • Lesson 14: The File System Object

    With the FileSystemObject you can access the server’s filesystem. This allows you to manipulate drives, folders and text files in ASP scripts. For example, you can use the {0}{1/}FileSystemObject{/0} to read or write a text file. Or you can list all files in a specified folder. There are many possibilities and the FileSystemObject can save you lots […]

  • Lesson 15: Reading from a text file

    In the previous lesson, we learned how to use the FileSystemObject to access the server’s filesystem. In this lesson, we will use this learning to read from an ordinary text file. Text files can be extremely useful for storing various kinds of data. They are not quite as flexible as real databases, but text file typically don’t […]

  • Lesson 16: Writing to a text file

    In the previous lesson, we learned to read from a text file. In this lesson, we will learn to write to a text file. The two methods are very similar, but there is one very important difference: You must have write permissions to the file. This means that the file will have to be located […]

  • Lesson 17: Databases

    There are many different databases: MS Access, MS SQL Server, Oracle SQL Server, MySQL and many others. In this tutorial, we will use the Microsoft Access database. Access is the natural place to start when you want to use databases in ASP. In this lesson, we will start by looking at the Access database that […]

  • Lesson 18: Database Connections

    To access a database, you need a database connection. In this lesson, we’ll look at how you can create a database connection. There are several options, but the simplest is a so-called DSN-less connection, which means a connection where you do not have to set up a Data Source Name (DSN) on the server, but create a shortcut […]

  • Lesson 19: Get data from database

    In the previous lessons, we have learned to create a database in Access and to make a database connection. Now it is time to retrieve content from the database to our ASP pages. This is really one of the most important lessons in this tutorial. Once you have read and understood this lesson, you will […]

  • Lesson 20: Insert data into a database

    When you have to insert new data in your Access database, you could download the entire database, manually entering data and then uploading the entire database again. But there is an easier way. In this lesson, we look at how you can insert data into the database directly from your ASP scripts. Insert data using […]

  • Lesson 21: Delete data from database

    In the two previous lessons, you have learned to retrieve and insert data into a database. In this lesson, we’ll look at how to delete records in the database, which is considerably easier than inserting data. Delete data using SQL The syntax for an SQL statement that deletes records is: DELETE FROM TableName WHERE condition Example 1: Delete […]

  • Lesson 22: Update data in a database

    In previous lessons, you have learned to retrieve, insert and delete data from a database. In this lesson, we will look at how to update a database, i.e. edit the values of existing fields in the table. Update data with SQL The syntax for an SQL statement that updates the fields in a table is: […]

  • All you need for ASP SCRIPT

    Microsoft Active Server Pages (ASP) let you combine HTML pages, script commands, and COM components to create interactive web pages or web-based applications that are easy to modify. This Microsoft technology was designed for creating dynamic, interactive web server applications. From ad management programs to web traffic scripts, you’ll find all sorts of ASP scripts […]