CSCI 4230
 Software Tools
 Spring 2000
 Homework #8

(1)    Write a Cold Fusion program, sqlquery.cfm, that accepts a sql statement to execute against an ODBC databse (using the DSN of your account).  Your Access database should contains three tables:

Supplier(SNum, SName, SCity, Status)
Part(PNum, PName, Color, Weight, PCity)
Supply(SNum, PNum, Quantity)

Your CF program should initially display a form.

The same program should handle form submission.  For example, the result of processing:

should be something like:

The order of the columns are not important.  Only select statements should be executed.  Other statements should be rejected.  For example, processing the form:

should result in:

Moreover, syntax error should be reported.  For example, processing the form:

should result in:

Try to adhere to the output pages above as close as possible.