Coldfusion Reservations Site

Posted on 2004-11-12
Last Modified: 2013-12-16
I am familiar with access and coldfusion and how they interact.  I would like to figure out how to setup a site that people can make reservations on.  The database would have a set number of reservations and a waitlist that would open once the reservations were maxed.  Any guidance?
Question by:bjv211
    LVL 24

    Accepted Solution

    yes - first dump access
    access is ok for testign and for single user or a maximum user group of 5 connections after that the usability deteriorats and access is memory intesive and expands to consume more harddrive spce with every read/write, use oracle or sql, if you don't have the money then get mysql, its free.

    next database design
    you need to normalize all your data in order to reduce redundant data being carried in multple tables, if you are not familiar with data normalization then you will need some help, this is a big part of making data storage and reteival easier

    tables - off teh top of my head
    Members - you will need some kind of members or user list to track the major details of the site users, the kind of info you gather will depend on your site needs,
    memberid (pk), lastName, firstName, email, address, phone ... you get the idea

    resid, typeid, locationid, maxreservations, costper (maybe, only if cost per reservation is fixed), closeDate

    resid, amenityId

    amenityId, amenityDesc

    memberId, resId, dateResMade (inc time), deposit (y/n), depositType(cash, cc etc.), depositAmount

    resType (used if you take multiple reservation types, air, bus, train, hotel, restraunt etc.)
    typeID, typeDesc

    like i said just off the top of my head, without having more details it would be impossiblre to properly desing a database

    once the db is designed the input output is easier to design and implement
    LVL 1

    Author Comment

    ok so i'll look into mySQL and get back to you, thanks for the start.  Oh sorry not to specify that this is a reservations site for tickets at a play theater.  So the info collected would be name address phone email quantity date of performance.  There would need to be a maximum of tickets reserved and then once those are filled, a waitlist.  In any case i'll try to get mySQL since you say that Access will be too much for multiple users.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
    When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure ( It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
    The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and Log…
    The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now