(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.