Stored procedures and the variables necessary to use them are database- and server
model??“dependent. A stored procedure on SQL server is completely different from a
ColdFusion stored procedure or another SQL-type database. The Stored Procedure/Command/Callable dialog
box may change based on the type of database to which you??™re connecting, as well as the server model.
2. In the Command/Callable/Stored Procedure field, enter a unique name.
3. From the Connection list, choose the connection in which this stored procedure may be found.
4. ASP users should choose Stored Procedure from the Type list.
The ASP Command (Stored Procedure) server behavior includes additional types: Insert,
Update, and Delete. These work identically to the Prepared (Insert/Update/Delete) server
behavior described in the following section on JSP server behaviors.
5. If the stored procedure returns a recordset, choose the Return Recordset option and enter a name
in the Returned Recordset Named field.
6. From the Database Items area, expand the Stored Procedure list and choose the desired stored
procedure. It??™s a good idea to click Test to be sure your connection is working properly at this
point.
7. To modify the stored procedure, select any other element in the Database Items area and click the
Column or Where button.
Pages:
1796
1797
1798
1799
1800
1801
1802
1803
1804
1805
1806
1807
1808
1809
1810
1811
1812
1813
1814
1815
1816
1817
1818
1819
1820