Setting the ColdFusion Stored Procedure dialog box options

The purpose of this dialog box is to insert a stored procedure into your ColdFusion page.

To set the dialog box options:

1. In the Data Source pop-up menu, select a connection to the database containing the stored procedure.
2. Enter the ColdFusion Data Source user name and password.
3. Select a stored procedure from the Procedures pop-up menu.

   Dreamweaver automatically fills in any parameters.

4. Select a parameter, then click the Edit button if you need to make changes.

   The Edit Stored Procedure Variable dialog box appears. To complete the dialog box, see Setting the Stored Procedure Variable dialog box options.

   NOTE

   You must enter test values for any stored procedure input parameters.

5. If the stored procedure takes a parameter, click the Plus (+) button to add a page parameter.

   The Add Parameter dialog box appears. To complete the dialog box, see Setting the Add Parameter dialog box options.

   NOTE

   You must enter corresponding page parameters for each stored procedure parameter return value. Do not add page parameters unless there is a corresponding return value.

   Click the Plus (+) button again to add another page parameter, if necessary.

6. Select a page parameter, then click the Minus (-) button to delete the parameter if necessary or click Edit to make changes to the parameter.

   The Edit Parameter dialog box appears. To complete the dialog box, see Setting the Add Parameter dialog box options.

7. Select the Returns Recordset Named checkbox, then enter a name for the recordset; if the stored procedure returns a recordset, click the Test button to see the recordset that the stored procedure returns.

   Dreamweaver runs the stored procedure and displays the recordset, if any.

   NOTE

   If the stored procedure returns a recordset and takes parameters, you must enter a value in the Default Value column in the Variables text box to test the stored procedure.

   TIP

   You can use different test values to generate different recordsets. To change test values, click Edit button for Parameter, then change the test value, or click Edit button for Page Parameter and change the default value.

8. Select the Returns Status Code Named checkbox, then enter a name for the status code, if the stored procedure returns a status code return value.
9. Click OK.

After you close the Stored Procedure dialog box, Dreamweaver inserts ColdFusion code in your page that, when run on the server, calls a stored procedure in the database. The stored procedure in turn performs a database operation, such as inserting a record.

Related topics

• Stored procedures
• Using stored procedures to modify databases (ColdFusion)