Click here to Skip to main content
Licence CPOL
First Posted 20 Jan 2000
Views 716,449
Downloads 1,115
Bookmarked 44 times

ASP Guestbook Application

By | 17 Oct 2000 | Article
A simple guestbook application using ASP and an Access database
  • 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

    Chief Technology Officer
    Zeta Producer Desktop CMS
    Germany Germany

    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:
     
    Free Test Management Software - Intuitive, competitive, Test Plans. Download now!  
    Homepage erstellen - Intuitive, very easy to use. Download now!  
    Send large Files online for free by Email
    Some random fun stuff in German


    Sign Up to vote   Poor Excellent
    Add a reason or comment to your vote: x
    Votes of 3 or less require a comment

    Comments and Discussions

     
    You must Sign In to use this message board. (secure sign-in)
     
    Search this forum  
     FAQ
        Noise  Layout  Per page   
      Refresh
    GeneralError: Can not insert record into database Pinmembersharp_k6:42 11 Mar '09  
    GeneralRe: Error: Can not insert record into database PinmemberNancy B4:47 20 Oct '09  
    Generalscreenshot Pinmembersharp_k17:44 8 Mar '09  
    GeneralMedicine for you PinmemberKedaar11:01 12 Oct '08  
    GeneralProbably it for you PinmemberKedaar6:27 17 Apr '09  
    GeneralHi!! PinmemberCharuT18:30 29 Oct '06  
    Very Good One! It was quite useful to me for a start. Thank you very much!
     
    Keep up the good work. Hope to contribute to CP soon!
     
    Smile | :)
     
    Charu.

    Generaltest for subject PinsussAnonymous15:30 16 Feb '04  
    GeneralRe: test for subject PinsussAnonymous5:34 31 Jul '04  
    GeneralRe: test for subject PinsussAnonymous21:17 9 Dec '04  
    Generalneed for a help Pinmemberreymar18:05 1 Aug '03  
    GeneralRe: need for a help PinmemberDavid Jhon17:31 17 Aug '06  
    Generalerr PinsussAnonymous5:01 27 Jul '03  
    GeneralSource Code Pinmemberlittleblack23:02 22 Jun '03  
    GeneralRe: Source Code Pinmember2TallTony4:37 23 Jun '03  
    GeneralDatabase access PinmemberIneffable14:07 7 May '03  
    GeneralRe: Database access PinsitebuilderUwe Keim19:28 7 May '03  
    Generaltask 1 PinsussAnonymous7:35 3 May '03  
    GeneralRe: task 1 PinsussAnonymous7:36 3 May '03  
    Generalmerhaba PinsussAnonymous13:11 2 May '03  
    Generalดดดดด PinsussAnonymousด21:52 26 Apr '03  
    Generaltest PinsussAnonymous1:46 4 Apr '03  
    GeneralRe: test PinsussAnonymous16:38 3 Mar '05  
    GeneralHello PinmemberZioner22:14 20 Feb '03  
    Generalhello PinsussAnonymous22:01 9 Feb '03  
    GeneralRe: hello PinsussAnonymous23:07 23 Feb '05  

    General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

    Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

    Permalink | Advertise | Privacy | Mobile
    Web01 | 2.5.120529.1 | Last Updated 18 Oct 2000
    Article Copyright 2000 by Uwe Keim
    Everything else Copyright © CodeProject, 1999-2012
    Terms of Use
    Layout: fixed | fluid