Click here to Skip to main content
15,892,768 members
Articles / Programming Languages / VBScript

ASP Guestbook Application

Rate me:
Please Sign up or sign in to vote.
4.33/5 (8 votes)
17 Oct 2000CPOL 886.2K   1.8K   45   147
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)


    Written By
    Chief Technology Officer Zeta Software GmbH
    Germany Germany
    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 has also teached programming to students at the local university.

    ➡️ Give me a tip 🙂

    In his free time, he does climbing, running and mountain biking. In 2012 he became a father of a cute boy and in 2014 of an awesome girl.

    Some cool, free software from us:

    Windows 10 Ereignisanzeige  
    German Developer Community  
    Free Test Management Software - Intuitive, competitive, Test Plans.  
    Homepage erstellen - Intuitive, very easy to use.  
    Offline-Homepage-Baukasten

    Comments and Discussions

     
    GeneralRe: testbook Pin
    ab30-Aug-00 14:21
    ab30-Aug-00 14:21 
    GeneralRe: testbook Pin
    fsddsfds4-Sep-00 11:33
    sussfsddsfds4-Sep-00 11:33 
    GeneralRe: testbook Pin
    rweqr12-Sep-00 1:09
    rweqr12-Sep-00 1:09 
    Generalstkjhkhjkh Pin
    Member 285461912-Sep-00 2:07
    Member 285461912-Sep-00 2:07 
    GeneralRe: testbook Pin
    wwwaaattt19-Sep-00 8:45
    wwwaaattt19-Sep-00 8:45 
    GeneralTest Pin
    testname2-Aug-00 4:00
    testname2-Aug-00 4:00 
    GeneralRe: Test Pin
    sdfsd30-Aug-00 0:03
    sdfsd30-Aug-00 0:03 
    Generalmax. 255 char test Pin
    muiiyuiyioi29-Jul-00 3:36
    muiiyuiyioi29-Jul-00 3:36 
    With a rain interrupted qualifying session, David Coulthard grabbed
    pole position five minutes into the hour, and was never challenged.
    Michael Schumacher managed to take second position in the final
    moments of qualifying, pushing Giancarlo Fisichella down to third place.

    Mika Hakkinen was fourth followed by Pedro de la Rosa and Jarno Trulli.

    It started to rain shortly before the qualifying hour started, so most of the cars
    attempted to put in a quick 'banker' lap. Within minutes of the session
    starting, Fisichella spun but then seemed to bring his car to a halt without
    touching anything. Only minutes later Barrichello stopped next to him. By five
    minutes into the session Gene had also crashed out.

    Within the first few minutes provisional pole swapped five times. Frentzen set
    the first time of 1.48.819, but in quick succession was superceded by
    Villeneuve, Trulli, Michael Schumacher and David Coulthard, who held
    provisional pole by a margin of 1.5 seconds with a time of 1.45.697.

    Within five minutes the frenetic activity had died down. Verstappen was the
    only one to venture out sixteen minutes into the session, as the rain stopped.
    Twenty minutes into the session Giancarlo Fisichella went out followed by
    Eddie Irvine and Michael Schumacher. Shortly afterwards Fisichella set the
    second fastest time of 1.47.130 just as it started to pour again and the cars
    returned to the pits. Half an hour into the session, with the rain still coming
    down, Barrcihello had still not set a time.

    With twenty five minutes of the session left, and the umbrellas being put
    away, Barrichello exited the pits. But the track was still very damp and his
    time of 1.56.723 was 3.7 seconds too slow to qualify with the provisional pole
    time of Coulthard at 1.45.697. The Brazilian's next lap was so slow that he
    came into the pits.

    Heinz-Harald Frentzen was stripped of his fastest time of 1.48.819 with only
    fifteen minutes of qualifying left. He had cut across chicanes on his out lap
    which meant he went to the front of the queue and the FIA deemed him to
    have gained track position. He immediately went out on wet tyres, but as the
    track had dried out decided to go back into the pits to wait while the track
    dried. He decided not to put in banker lap. He had not yet qualified.

    With nine minutes of the qualifying hour left, and every driver with at least two
    runs left, Ralf Schumacher was the first to exit the pits. Several cars followed
    him out. No times were improved, and with the clock down to five minutes to
    go, Michael Schumacher exited the pits. Frentzen set 19th fastest time, but
    Barrichello still did not qualify on his eighth lap. On his next lap the Brazilian
    made it into 17th position.

    In the final moments, with the rain starting again, Michael Schumacher
    managed to take second position from Fisichella with a time of 1.47.063. This
    was the only major time improvement at the top of the grid.
    Generalf*** usa kakakaka Pin
    fuck20-Jul-00 17:00
    fuck20-Jul-00 17:00 
    GeneralRe: f*** usa kakakaka Pin
    SFSS12-Sep-00 11:05
    SFSS12-Sep-00 11:05 
    GeneralUmmm Pin
    aaah26-Jun-00 21:07
    aaah26-Jun-00 21:07 
    Generalryj Pin
    ghj15-Jun-00 7:31
    ghj15-Jun-00 7:31 
    GeneralRe: ryj Pin
    ghj15-Jun-00 7:31
    ghj15-Jun-00 7:31 
    GeneralGB Pin
    Noel14-Jun-00 21:23
    Noel14-Jun-00 21:23 
    GeneralHummm.... Pin
    WestBloot9-Jun-00 6:50
    sussWestBloot9-Jun-00 6:50 
    GeneralTesting GB Pin
    test1237-Jun-00 11:20
    test1237-Jun-00 11:20 
    GeneralRe: Testing GB Pin
    Anonymous20-Oct-02 13:43
    Anonymous20-Oct-02 13:43 
    Generalwho knows Pin
    ituotty2-May-00 8:18
    sussituotty2-May-00 8:18 
    Generalmsg for author Pin
    Igor Rendulic13-Apr-00 4:54
    sussIgor Rendulic13-Apr-00 4:54 
    GeneralTesting Pin
    Eric Yao3-Apr-00 18:06
    Eric Yao3-Apr-00 18:06 
    Generalww Pin
    Member 1081011129-Mar-00 6:14
    Member 1081011129-Mar-00 6:14 
    GeneralRe: ww Pin
    Member 1081011129-Mar-00 6:15
    Member 1081011129-Mar-00 6:15 

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

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