
1200
Part VII
Extending Dreamweaver
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.
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 Select or Where button.
8. Enter any necessary variables by clicking the Add (+) button in the Variables area and entering
the values under each column: Name, Type, Direction, Size, Default Value, and Runtime Value.
9. Click OK when you’re finished.
Installing Additional Server Behaviors
Although Dreamweaver’s standard server behaviors perform many important functions, they’re just
the tip of the iceberg in terms of what’s possible. You can add additional server behaviors—whether
created by Adobe, yourself, or a third party—at any time. Although you can transfer f ...