Setting the ColdFusion Stored Procedure dialog box options

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.

  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.

    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.

  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)


Getting Started with Dreamweaver
Dreamweaver Basics
Working with Dreamweaver Sites
Laying Out Pages
Adding Content to Pages
Working with Page Code
Preparing to Build Dynamic Sites
Making Pages Dynamic
Developing Applications Rapidly
Building ColdFusion Applications Rapidly
Reference
Building ASP.NET Applications Rapidly
Building ASP and JSP Applications Rapidly
 
ASPTreeView.com
 
Evaluation has №В»Шёexpired.
Info...