Category Archives: ASP

ASP Program Examples

ASP Database Inserts 2

The insert statement that we originally used to insert data into our database is the most elementary version. We are going to look at a more efficient and faster method of inserting data into our database. We are using a SQL statement. SQL is short for Structured Query Language. This is the language used with most databases. SQL will have minor syntax differences depending on the database you are using. For now, we are using an Access 2000 database. Our insert statement takes the form of:
Continue reading ASP Database Inserts 2

Times Viewed: 27

ASP Database Connections

Here’s our first tutorial in ASP. If you’ve read the introduction, you might remember that we talked about how the majority of ASP tasks are for database related reasons. Well, this tutorial will tackle the first hurdle in database interaction – making the connection. To create a connection to a database, you have 3 choices. You can either specify a path to the database, reference a DSN or you can use the Server.MapPath option. I always use the first option so that I don’t have to worry about any problems with a DSN or the MapPath option. I have had problems with these last two options before.
Continue reading ASP Database Connections

Times Viewed: 45

ASP Arrays

I don’t know about you, but arrays have always been a weird topic for me. I’ve never really found a good use for them in my applications, but I know they do have their uses. So today, we’re going to start off with a regular array expression, explain what it is and how to go through it to show our values.
Continue reading ASP Arrays

Times Viewed: 32


Passing An ID with a Hyperlink

For anyone who’s worked with ASP, this article is old hat stuff. But hey, we’re working with newbies here, so don’t worry about it. In today’s lesson, we’re going to do a couple of things. First we’re going to create a small page that pulls information from a database. Then we’ll make it into a clickable link. The link will pass an ID to a second page that will pull the remainder of the data based on the ID that was clicked. So here we go…

Continue reading ASP Link ID

Times Viewed: 23