Setting the Add Parameter dialog box options

The Add Parameter dialog box lets you define parameters contained in a SQL statement by entering the parameter’s name and default value (the value the parameter should take if no runtime value is returned).

To define SQL parameters:

1. Select a parameter name from the Name pop-up menu.
2. Enter a default value for the parameter in the Default Parameter text box.

   The default value is the value the parameter should use if no runtime value is returned.

3. Click OK.

Related Topics

• Using stored procedures to modify databases (ColdFusion)
• Setting the ColdFusion Stored Procedure dialog box options
• Setting the advanced Recordset dialog box options (ColdFusion)
• Retrieving form and URL parameters.