Setting the ColdFusion MX Stored Procedure dialog box options The purpose of this dialog box is to insert a stored procedure into your ColdFusion page.
Procedure
In the Data Source pop-up menu, select a connection to the database containing
the stored procedure.
Enter the ColdFusion Data Source user name and password.
Select a stored procedure from the Procedures pop-up menu.
automatically fills in any parameters.
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 Stored Procedure Variable dialog box options.
Note: You must enter test values for any Stored Procedure input parameters.
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 or Edit 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.
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 or Edit Parameter dialog box options.
Select the Returns Recordset Named checkbox, then enter a name for the recordset,
if the stored procedure returns a recordset, and then click the Test button
to see the recordset that the stored procedure returns.
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.
Tip: You can use different test values to generate different recordsets. To change test values, click the Edit button for Parameter, then change the Test Value or click the Edit button for Page Parameter, then change the Default value.
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.
Click OK.
After you close the Stored Procedure dialog box, 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.
1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 422