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: 12

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: 19

ASP Link ID

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: 13