Running the stored procedure in ColdFusion With ColdFusion pages in , you must add a Stored Procedure server behavior to a page to run a stored procedure.
To add a stored procedure to a ColdFusion page:
In , open the page that will run the stored procedure.
In the Bindings panel, click the plus (+) button, and then select Stored Procedure.
The Stored Procedure dialog box appears.
Complete the dialog box.
The dialog boxes for ColdFusion 4 and ColdFusion MX are different.
For ColdFusion 4 instructions, see Setting the ColdFusion 4 Stored Procedure dialog box options. For ColdFusion MX instructions, see Setting the ColdFusion MX Stored Procedure dialog box options.
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.
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.
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