ISM3011 - E-Business System Fundamentals
Eighth Project Information
Your Cold Fusion project will be a lot of fun - I promise. Cold Fusion is a "gateway" between database files and HTML. It links your web page to a database set up by your company's database administrator (me in this case). As you will see, it is easy to access the data and incorporate it into your web page.
I have developed some Cold Fusion resources to help you. (Am I a nice guy or what!)
- A brief Introduction to Cold Fusion can be found at this link. The basic commands you need to construct your Cold Fusion document are provided here.
- Since Cold Fusion uses SQL (Structured Query Language) to query the database, I have also prepared a brief Introduction to SQL.
- You will find a brief Introduction to Input Forms at this link. Forms permit users to specify input values to control the search of the database for specific data. The association of a form in an HTML document and the resulting Cold Fusion SQL query is also illustrated.
- This link will take you to my Cold Fusion example , the one developed in the three resources above. When you click on this link, you "run" the form in the HTML document. When you click on a state, you specify a value for the "stateval" that is passed to the CFM file. This state value is used as the argument in the WHERE clause in the SQL statement. When you click on the "Submit" button in the HTML file, you "launch" the CFM file that executes the SQL statement. The data are read from the datafile, then displayed on your screen.
Your job is to set up an HTML document that will permit the user to specify the state, the category, the channel, and the price range of the data in the Proj3data.mdb database. I've given you all the pieces, now put them together and amaze your family and friends!!!!
Return to ISM3011 Page