Also refer to forms, database, query, SQL, output, code, School for Champions, Kurtus Technologies, Milwaukee, Wisconsin. Drop-down lists or menus are often used to facilitate selections when entering data. Programming those lists in ColdFusion can be tricky, especially when you are using data from multiple tables in the database. This lesson will answer those questions. There is a mini-quiz at the end of the lesson.
NAME is the name of the variable being posted or the record or column of the table in the database.
For example, Apples could be inserted in the Fruits column. If these items are in a database, you can use ColdFusion to display them, instead of writing each out individually. Note that the list comes from the FruitList table, but the selection will be going to the Fruits database table. If it is located anywhere else, you will get unusual results. Suppose you had a page to edit a record, using a drop-down list.