Click here to Skip to main content
6,295,667 members and growing! (11,970 online)
Email Password   helpLost your password?
Web Development » ASP » Applications     Intermediate License: The Code Project Open License (CPOL)

ASP Guestbook Application

By Uwe Keim

A simple guestbook application using ASP and an Access database
VBScript, ASP, Visual Studio, Dev
Posted:20 Jan 2000
Updated:17 Oct 2000
Views:646,133
Bookmarked:39 times
Announcements
Loading...
 
Search    
Advanced Search
printPrint   Broken Article?Report       add Share
  Discuss Discuss   Recommend Article Email
55 votes for this article.
Popularity: 6.90 Rating: 3.97 out of 5

1

2
1 vote, 16.7%
3
3 votes, 50.0%
4
2 votes, 33.3%
5
  • Download source files - 15 Kb

    Overview

    This is a small ASP (Microsoft Active Server Pages) application that implements a guestbook.

    The guestbook has the following main-functionality:

    • Display entries with author-name, e-mail, date and text
    • Administration mode: delete entries
    • Navigation: jump to first page, last page, previous page, next page, discrete pages

    The sample is ready-to-use. As-few-as-possible HTML-formating (e.g. fonts) is done in order to keep it clear. You could modify the following things:

    • Change the language of the texts
    • Adjust the design to your needs
    • Extend the functionality (please e-mail me, if you improved it, since I'm very interested in any improvements)

    Details

    The guestbook stores its entries in a Microsoft Access 2000 database (Access 97 works quite well, too - just convert the database) and accesses the database using ADO (Microsoft ActiveX Data Objects, see http://www.microsoft.com/data/ado/). To use the Access 2000 database, you probably need the latest version of the Microsoft Data Access Components (MDAC, also from http://www.microsoft.com/data/ado/).

    I tried to comment the ASP code as well as I can. When you look through it with a syntax-coloring editor, you should find the comments quite easily. I also tryied to minimize the allways-present problem of having code mixed with design/content be separating ASP from HTML as much as I can. Still I wanted to keep all things in one file to make it compact. So the ASP pages became a bit longer than it normally would.

    I'm running this guestbook under a german version of NT 4.0 server, service pack 6a (the 'a' is very important). Altough, SP 4 or 5 should be no problem, too.

    A last tip for editing ASP files: I tried a lot of editors (including Frontpage, InterDev, etc.), I found the most usable program is EditPlus, which you can find on http://www.editplus.com/.

    Please feel free to ask any questions you have by e-mail: keim@zeta-software.de.

    History

    18 Oct 2000 - updated script.

  • License

    This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    About the Author

    Uwe Keim


    Member
    Uwe does programming since 1989 with experiences in Assembler, C++, MFC and lots of web- and database stuff and now uses ASP.NET and C# extensively, too. He is also teached programming to students at the local university.

    In his free time, he does climbing, running and mountain biking. You can watch him most of the day (and probably night) programming.

    Some cool, free software from us:

    -----

    Zeta Test

    Zeta Test is an integrated test management environment that enables you to perform black-box tests, white-box tests, regression tests or change management tests of software applications.

    Zeta Test helps you to plan, perform, log, monitor and document the tests, and then to evaluate the test results.

    Create and manage your test cases and test plans with Zeta Test. Test your software with test scripts that you created with Zeta Test.

    Directly download Zeta Test for free!

    -----

    Zeta Producer Desktop CMS

    Intuitive, completely easy-to-use CMS for Windows. Both Freeware version and full version available.

    Try out by yourself now! (direct download)

    -----

    Zeta Uploader

    Easily send large files by e-mail. Windows and web client available.

    -----
    Occupation: Software Developer
    Company: zeta software GmbH
    Location: Germany Germany

    Other popular ASP articles:

    Article Top
    You must Sign In to use this message board.
    FAQ FAQ 
     
    Noise Tolerance  Layout  Per page   
     Msgs 1 to 25 of 146 (Total in Forum: 146) (Refresh)FirstPrevNext
    GeneralError: Can not insert record into database Pinmembersharp_k7:42 11 Mar '09  
    Generalscreenshot Pinmembersharp_k18:44 8 Mar '09  
    GeneralMedicine for you PinmemberKedaar12:01 12 Oct '08  
    GeneralProbably it for you PinmemberKedaar7:27 17 Apr '09  
    GeneralHi!! PinmemberCharuT19:30 29 Oct '06  
    Generaltest for subject PinsussAnonymous16:30 16 Feb '04  
    GeneralRe: test for subject PinsussAnonymous6:34 31 Jul '04  
    GeneralRe: test for subject PinsussAnonymous22:17 9 Dec '04  
    Generalneed for a help Pinmemberreymar19:05 1 Aug '03  
    GeneralRe: need for a help PinmemberDavid Jhon18:31 17 Aug '06  
    Generalerr PinsussAnonymous6:01 27 Jul '03  
    GeneralSource Code Pinmemberlittleblack0:02 23 Jun '03  
    GeneralRe: Source Code Pinmember2TallTony5:37 23 Jun '03  
    GeneralDatabase access PinmemberIneffable15:07 7 May '03  
    GeneralRe: Database access PinsitebuilderUwe Keim20:28 7 May '03  
    Generaltask 1 PinsussAnonymous8:35 3 May '03  
    GeneralRe: task 1 PinsussAnonymous8:36 3 May '03  
    Generalmerhaba PinsussAnonymous14:11 2 May '03  
    Generalดดดดด PinsussAnonymousด22:52 26 Apr '03  
    Generaltest PinsussAnonymous2:46 4 Apr '03  
    GeneralRe: test PinsussAnonymous17:38 3 Mar '05  
    GeneralHello PinmemberZioner23:14 20 Feb '03  
    Generalhello PinsussAnonymous23:01 9 Feb '03  
    GeneralRe: hello PinsussAnonymous0:07 24 Feb '05  
    Generaltest PinsussAnonymous11:29 21 Nov '02  

    General General    News News    Question Question    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

    PermaLink | Privacy | Terms of Use
    Last Updated: 17 Oct 2000
    Editor: Chris Maunder
    Copyright 2000 by Uwe Keim
    Everything else Copyright © CodeProject, 1999-2009
    Web20 | Advertise on the Code Project