This dialog box defines a recordset for ColdFusion document types as a source of dynamic content without you having to hand code SQL statements.
NOTE |
|
If you are creating recordsets for use with ColdFusion 5 or earlier, use the generic Simple Recordset dialog box common to other document types such as ASP and JSP. |
A common practice is to add the prefix rs to recordset names to distinguish them from other object names in your code. For example: rsPressReleases
Note that recordset names can only contain letters, numbers, and the underscore character (_). You cannot use special characters or spaces.
NOTE |
|
The Function pop-up menu is only available if a CFC file is the current document and you have access to a computer running ColdFusion MX 7 or better. For more information, see Enabling the ColdFusion enhancements. |
The recordset will be defined in the function. For more information, see Defining a recordset in a ColdFusion component.
If no data source appears in the pop-up menu, you will need to create a ColdFusiondata source.
Data sources in ColdFusion may require a user name and password to access them. If you do not have the user name and password to access a data source in ColdFusion, contact your organizations ColdFusion administrator.
The Table pop-up menu displays all tables in the specified database.
If the specified value in a record meets your filtering condition, the record is included
in the recordset.
A table appears displaying the returned data. Each row contains a record and each column represents a field in that record. Click OK to close the test recordset.
The newly defined ColdFusion recordset appears in the Bindings panel.