ASP Discovery

nathan schmoll's
aspdiscovery

back to main page

e-mail me

<script language="javascript" src="http://ads.aspalliance.com/displayad.aspx?t=2&m=1&target=_parent&js=1&s=aspdiscovery&page=0.9777565572028759"></script>

<script language="javascript" src="http://ads.aspalliance.com/displayad.aspx?t=2&m=1&target=_parent&js=1&s=aspdiscovery&page=0.1282027309237308"></script>

<script language="javascript" src="http://ads.aspalliance.com/displayad.aspx?t=2&m=1&target=_parent&js=1&s=aspdiscovery&page=0.03480888777179586"></script>

<script language="javascript" src="http://ads.aspalliance.com/displayad.aspx?t=2&m=1&target=_parent&js=1&s=aspdiscovery&page=0.769246103131557"></script>

Building an article management system -- Part IIII

<< Go to back to part three

Welcome to the last part in a four-part tutorial on how to make an article management system utilizing the powerful database capabilities of Active Server Pages!

In this article I will discuss every part of the "article.asp" script we made in part three, and also give you ideas on how to implement it into your own site.

Okay, I will begin explaining the code. To request an article from the article.asp page, just tell it the article ID number in the querystring in a variable called "id". Example: "http://www.ebizlocal.com/articles/article.asp?id=1046". The script starts out by connecting to a table called "articles" in an Access database called "articles.mdb". It selects all rows and columns and searches for the ID number that was passed to it via the querystring. If the ID exists, it pulls all the information about the article from the database and sets the variable "showvalidpage" to "1". After it does its database jazz, it asks if "showvalidpage" equals "1". If it does, it formats the article pulled from the database. If it doesn't, then there's an error message returned, telling the user that the article they requested no longer exists.

Ideas for implementing:

Have a daily article about your business' field to get return visitors

Like a certain subject? Just make a big web site of articles about it

You could write daily article about a creative way to use your software product

I hope that you now have an idea for a basic article management system and how it can utilize ASP's incredible database capabilities!