Operation Manual

682
Building applications visually
Last updated 11/30/2015
9 Select a page parameter, and click the Minus (-) button to delete the parameter if necessary or click Edit to make
changes to the parameter.
10 Select the Returns Recordset Named option, and 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 box to test the stored procedure.
You can use different test values to generate different recordsets. To change test values, click the Edit button for
Parameter, and change the test value, or click the Edit button for Page Parameter and change the default value.
11 Select the Returns Status Code Named option, enter a name for the status code, if the stored procedure returns a
status code return value. Click OK.
After you close the box, Dreamweaver inserts ColdFusion code in your page that calls a stored procedure in the
database, when the code runs on the server. The stored procedure in turn performs a database operation, such as
inserting a record.
If the stored procedure takes parameters, you can create a page that gathers the parameter values and submits them
to the page with the stored procedure. For example, you may create a page that uses URL parameters or an HTML
form to gather parameter values from users.
Run a stored procedure (ASP) (CS6)
With ASP pages, you must add a command object to a page to run a stored procedure. For more information on
command objects, see
About ASP command objects.
1 In Dreamweaver, open the page that will run the stored procedure.
2 In the Bindings panel (Window > Bindings), click the Plus (+) button, and then select Command (Stored
Procedure).
The Command dialog box appears.
3 Enter a name for the command, select a connection to the database containing the stored procedure, and then select
Stored Procedure from the Type pop-up menu.
4 Select your stored procedure by expanding the Stored Procedures branch in the Database Items box, selecting the
stored procedure from the list, and clicking the Procedure button.
5 Enter any required parameters in the Variables table.
You don’t need to enter any parameters for any RETURN_VALUE variable.
6 Click OK.
After you close the dialog box, ASP code is inserted in your page. When the code runs on the server, the code creates
a command object that runs a stored procedure in the database. The stored procedure in turn performs a database
operation, such as inserting a record.
By default, the code sets the Prepared property of the Command object to true, which makes the application server
reuse a single compiled version of the object every time the stored procedure is run. If you know the command will
be executed more than a few times, having a single compiled version of the object can improve the efficiency of
database operations. However, if the command will only be executed one or two times, using one might actually slow
down your web application because the system has to pause to compile the command. To change the setting, switch
to Code view and change the Prepared property to false.