CIS 430 Assignment – Coldfusion

Create a Coldfusion page that connects to both the SQL Server database and the MySQL database and displays a catalog page consisting of the contents of each.  You can download and install Dreamweaver to create the page, although it is not required.  (The page can also be created using a standard text or html editor.)

The datasource for the SQL Server database is productsSQL.

The datasource for the MySQL database is productsMySQL.

No other connection information is required by Coldfusion--it is established by the database administrator.

Use the Coldfusion presentation as an example.

As always, the assignment will be considered complete and submitted only when you link it to your index page.

Database table details (same in both database tables):

• Table name: Products

• Field1: productID

• Field2: productName

• Field3: productDesc

• Field4: productpicurl

Hint:  You may experience some difficulty in getting the images to display.  It probably has something to do with the level of the folder in which your Coldfusion file is stored versus the level of the folder in which the images are stored.

Aside from the fact that much of the setup work is done by the database administrator, what advantages do you see in using Coldfusion over ASP.Net?  (This assumes that you successfully figured out how to connect to the databases in the previous assignment.)